Sign in to join the conversation:
I am trying to setup a Conditional Format formula to format a cell only when the cell contains a linked value of "Sheet Link from Cell in Other Sheet"
Shortest answer is to use a hidden helper column. Make a new column name it hidden and post the cell link at the top. Use an if statement, =if(columnheaderhere@row=$hidden$1,1,0 then use the conditional formatting tool to check if there is a 1 in the hidden column. When you are done simply hide the column.
GL
I have existing sheets, reports and dashboards I would like to rename. I am going into the sheet etc. selecting file, rename, renaming and then clicking out of the name box. it appears to have worked. However, when I go back to browse the file reverted back to the previous name. I'm not sure what I am doing wrong.
This discussion was created from comments split from: Workaround for Grouped Reports with multi-select dropdowns.
Good afternoon, Somehow I deleted an entire smart sheet of information. I went into the activity log and I was able to take a snapshot, but now Smartsheet is not letting me import the new information in the smart sheet