-
INDEX_MATCH equation help
Hi. I have 2 master data sheets (Sheet A and Sheet B). Both sheets have a column called [Company Name]. On Sheet A, i need an equation that looks at [Company Name] in Sheet A, then searches for a match in Sheet B. If there is a company name match in Sheet B, then I would like to return the value of a different columnβ¦
-
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.'β¦
