-
Status Flow with If Statements
Here is my first IF statement that when the Site Survey task gets populated it puts it into the complete status. =IF(ISBLANK([Order Sign Date]@row), "", IF(ISBLANK([Site Survey Complete Date]@row), "Pending", "Complete")) Now that I am able to get the next task ROE in progress with the Site Survey task completed I am…
-
Formula if check box is checked, run one formula, if not run another formula
Hi! What’s the best way to write that in a Smartsheet formula? If the checkbox is not checked, I want to do this: SUMIFS({Column 1}, {Name}, Name@row) - [OOO] - [Hours] - [Holidays] If the checkbox is checked, I want to do this: SUMIFS({Column 1}, {Name}, Name@row) - [OOO] - [Hours] Thanks
-
Preference sheet
I am trying to make a sheet where a colleague will be able to go through the current job bids, select the ones they want to bid on by preference(1st, 2nd,3rd ect…). If they only a few jobs they want to bid on i have made this however, if there are 20+ jobs, how can i create sheet that can accommodate this. I don't want 20+…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Formula that retains the last number when another field is updated
hi all, I am building a formula off of the net working days between when a row as completed and today; which I have working. I want it to calculate the net days when it is in a certain project phase, which I have as well. The issue is that when the project phase changes, my formula value goes away. How do I update my…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Changing a cell Value to different cell value when a 3rd cell changes
I would like the last row on the right to change to the cell that says "framing" ONLY when the first cell shows "In Progress." Is this possible? I've been trying this for a few hours now…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…
-
Formula & Placement for Automating Status based on End Date
Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it! Goal: Automate Status column updating When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.'…
-
Can someone please help with this formula?
I keep getting an "invalid operation" error message with this formula. Can someone spot where I went wrong? I am not great at formulas. The goal is for multiple criteria (IF statements) to match before entering "Inactive" in the cell. =IF({Master Cadre Roster Range 1} = [First Name]@row, IF({Master Cadre Roster Range 3} =…