-
Auto checkbox problem
Hi, I am using these two formulas to auto check a box. =IF([Column Title1]@row = "Word", 1) =IF(ISDATE([Column Title2]@row),1) Both work individually, but i am having trouble nesting them and making them work together. I need the check box column formula to check for a word (single select dropdown) in one column and a date…
-
Automated Workflow Execution Time
I have created several automated workflows, which should be initiating as soon as something changes in the sheets, however to get it to work I am having to save and refresh my page every time. Have I made a mistake when creating the workflows or is that normal?
-
How to flag a row if a checkbox is unchecked for more than 2 weeks in a row
My team uses a hierarchical sheet to track weekly student attendance by checking the 'Check In Data' box if a student is present. I want to create a column or formula that will flag a row if the 'Check in Data' box is unchecked for TWO WEEKS in a row. I can easily create a flag column that inserts a flag if that week's…
-
How best to copy partial information from one column into another?
I am using IF(ISBlank) and IF(Contains) together to automatically populate a a cell in one column from data in an adjacent cell/column, but the formula won't let me add any more combinations of the formula to complete this task for about 80 pieces of data. (The formula tops out at 61 in this scenario and won't let me add…
-
Update date column when another column drop-down is selected
Looking for the formula to change a column to a date when another column drop-down is selected. The date would reflect the actual date the column drop-down list was selected Example If EPMO Stakeholder Decision (Approved, Declined, Deferred) is selected The EPMO approval date will auto-update to the date when the EPMO…
-
Match Contact column list to Email Address
Has anyone found a practical solution to match a Contact column to an email address? It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a method to do this that doesn't require a lot of manual intervention. The problem with Smartsheet Contacts is that people can…
-
SUMIFS formula that includes a checkbox condition
Hi everyone, I'd like to sum all cells in a column that are (A) in a parent row (B) have a certain name in the Producer column. I've inserted a checkbox column (called "Parent") with a formula to check the box if the row is a parent row (which works) but I can't get the SUMIFS formula to work. I've pasted the two I've…
-
IF Function
I'm trying to create a Function where, if the status column is marked as "Completed" then the checkbox in the done column is activated. I'm not quite sure how to do that, can anyone help?
-
Return a value, if a cell contains text from a range of options
Hi there! I'm not sure if there's an easy way to do this, so I'll try to break this out into parts: 1) I have a table with two columns - one with various text options (for easy, let's call these "flavours"), the other with the "type" or category that these text options would fit under 2) On a separate sheet, I want to see…
-
Sort data conditionally from one sheet to another
Hello, I am looking to take the rows from one sheet that have "x" in column 15 and output all of them in another sheet. the closest that I've gotten is: =INDEX({Page 1 Range 1}, MATCH("X", {Page 2 Range 2}, 0), 1) Which when placed in row 1 column 1 on Page 2, pulls the first matching result in row 1. I have each column…