-
Is TODAY() supported as a Sheet Summary Field?
I am trying to get a sheet summary field on my project plan to count the number of tasks which have fallen behind plan. However I do this, I am using the TODAY() function, either in a sheet column or in the summary field itself. Here is one example of something I tried in the sheet summary field: =COUNTIFS(Status:Status <>…
-
Find and Highlight duplicates in column
Hi, I'm trying to find a formula to highlight duplicate values in a column in Smartsheet. I think I have tried every formula that I can find online and in this Community, but all come back with #unparseable error. The column "Duplicate" in checkbox type is created and waites to be used. Similar formulas as mentioned below…
-
Auto-update formulas when pasted into new column
Similar to excel.. it would be great to have variable cell references so that formulas could be copied to a new column. Currently, we have to manually click into the formula to make adjustments so that reference cells are updated. e.g., if I have a formula in column 3 that points to column 2, but need to copy the formula…
-
Merged: Combining contact columns
This discussion has been merged.
-
INDEX/Match Error?
Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…
-
Formula to return value based on multi options in another cell
Hey SS community, Hoping someone can support on this one. I've been searching and searching and not been able to find the answer as of yet! I'm working on a sheet that contains answers to an assessment. The answers are captured form an external form (ms forms) and added to Smartsheet via Powerautomate. One of the questions…
-
Automating Start Date
Hello, In my sheet I have a "Start Date" column that I would like to automate. In a separate status column I have a drop down option that includes, "Not-Started", "In Progress", "Completed". Once the status column is switched to "In Progress" I would like the Start Date column to automatically post the current date. Once…
-
Uncheck box when the value in the dropdown changes
Hello community As the title states, I'm trying to have boxes uncheck when the value in the dropdown changes. I have attached an image. When "Stage" column changes clear "Fit Plan Attached", "Approval Sent", & "Approval" column check boxes.
-
Trigger Checkbox check once week meets criteria
Hi Smarties, I have a Checkbox column that will be checked automatically when an End Date is met. This checkbox is then used in a report and published that particular row in a dashboard. =IFERROR(IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()) - 1, 1), "") However, I totally overlooked that this will also trigger…
-
Formula Question
Hi Everyone! I am trying to create a formula for the following. I have been trying IF, IF/AND, and IF/OR, but I just can't seem to get it right. I have 5 approval columns in a spreadsheet. Each column has a drop down and the person approving will select approve or reject. I then have a 6th column that will be the final…
