Either move the formula to a different column or convert the result to the appropriate type. Add an empty string to convert formula results to text values. For example =TODAY() + "" allows you to enter today's date into a text column. #DIVIDE BY ZERO Cause Your formula attempted to di...
Re: I want to get a column in Smartsheet to appear in my ComboBox. I have tried all the suggested formula in MS Documentations but nothing works. I must be doing something wrong, Please help. Hi @-aj , All right, I found another meth...
You can input new values in cells that contain cell formulas, but the workflow doesn't run if you convert a cell formula to a column formula. Cells with a cell-link or cross-sheet formula don't trigger the Change cell value action. You must specify the exact value you want to input...
For the C-suite, start by enumerating tangible benefits, such as costs, error numbers, returns, order-to-cash cycle durations, and returns on investment. After articulating these positive points to upper management, you can work your way toward the less tangible benefits, like customer service ...
I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept getting error messages or other strange...
Insert a formula Add headers to a column Open a document (e.g. csv file, xlsx file) Remove duplicate rows Add or remove sheets Convert a vector (i.e. a row) to a matrix Convert a matrix to a vector Copy a cell’s format
Formula Help Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our… Answered ✓ ...
Re: I want to get a column in Smartsheet to appear in my ComboBox. I have tried all the suggested formula in MS Documentations but nothing works. I must be doing something wrong, Please help. Hi @-aj , All right, I found another meth...
To find the rows containing a pure number value using a filter, you need to convert the number to text. You can do that by creating a new column and the formula: =[NumberColumn]1 + "" where [NumberColumn] is the name of the column and row number is 1. Copy that formula to the...
Use this function in a Date column to extract the date portion of a date/time value. Syntax DATEONLY(date_time) date_time— Reference to the date/time cell that contains the value from which you want to extract the date. Sample usage DATEONLY([Due Date]5) Usage notes Only values in...