I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "information reviewed" column only when the study status column reads "completed?
I want a cell to change colour if the row/s were created in the past of a certain date. For instance any row that was created before 1st May 2024 will have a cell change colour. Anything after that date will not be affected. Is this possible?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
I'm drawing a blank on the best way to do this. I am building a form where there is an option to select criteria from a drop-down. When someone selects a drop-down option I want it to then link to it's accompany account number. Basically, that way when they select their account name and submit the form it is submitted with…
This discussion has been merged.
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
Hello, I wanted to know if there is functionality for the following: I have two sheets, #1 Master and #2 Calendar. I have set up an automatic workflow: when a tick box on sheet #1 Master is ticked, a row is copied to sheet #2 Calendar. I then realised that if I needed to update anything on #1 (after the row was copied…
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
Currently there isn't a way to color code cards/line items in the SmartSheet app. This would be a huge help for triaging tasks to the correct group as its easier to identify a color than a small text on a handheld device.
