400 1161 Cannot set altText for a cell that does not contain an image: row {0}, column {1}. 400 1162 A formula must always start with an equal sign (=). 400 1163 If cell.image is non-null then value, objectValue, hyperlink, and linkInFromCell must all be null. 400 1164 Cannot...
...If the column that contains the formula is not a Date column type, the latest date in the range can't be returned. Learn more about theMAX Function. Resolution Make one of the following adjustments to your sheet: Type the formula in a different column, one where its type aligns with...
Default allocation is not applied to rows that have a column formula in the allocation column. Workload heatmap After you turn on workload tracking for your project in the Resource Management panel, the panel shows a workload heatmap that highlights over-allocation. The workload heatmap allows...
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. I am not sure what I am doing wrong. But...
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...
You can see for the Unique ID 0051 - there are 5 entries, one is Initial, and four are amendments. What I would like to do is, in the Task Number column, create a formula that says, look at the Budget Action Requested, if it's 'Initial', then just put the Unique ID, if it'...
Hello, I am struggling to get my IF formula to give me anything other than #UNPARSEABLE I am creating an inventory sheet where if "Stock qty" column is less than "Reorder level" qty than to return "RE… Answered ✓ Formulas and Functions ...
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. I am not sure what I am doing wrong. But...
3. Type the first VLOOKUP formula in cell E2: =VLOOKUP(A2,C:C,1,FALSE) Breaking down this formula: Argument Value Meaning Lookup_Value A2 The Staff Name of reference you are looking to see in the List of Participants Table_array C:C C:C refers to column C (List of Participants), ...
Place the alphanumeric data in theText column(this is the basis for the barcodes). The barcodes will appear in theBarcodecolumn. Note: If you want to add a description of each item the barcode applies to, add additional columns to make a table-like layout. ...