-
Need help creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. -- If columns "Reviewer Assigned" and "Approver Assigned" are not blank, I want the status to automatically change to "In progress." --…
-
Unparseable???
I am trying to figure out why my formula keeps saying #UNPARSEABLE I am trying to take the first four digits of a project number and join it with 2 digits that are the suffix to create a new project number. Please help! Here is the formula: =JOIN(MID([Project Number]1,1,4):[Project Number Suffix]@row)
-
If Formula with Dropdown conditions
I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation. Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are. If the 3 that are entered below are true it should enter the value…
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Need assistance creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. If Columns A, B, and C are blank, I want the status to automatically change to "Not started." If Columns A or B are not blank, I want…
-
My formula with reference to another sheet is no longer working.
It was working fine and then just seemed to break. Below is my formula. I'm doing check for PTO which we maintain in a dif smartsheet. =IF(OR(COUNTIFS({RDI Calendar Range 1}, [Assigned To]@row, {RDI Calendar Range 2}, >=Start@row, {RDI Calendar Range 3}, <=Finish@row) > 0, COUNTIFS({RDI Calendar Range 1}, [Assigned…
-
Need help with "WEEKNUMBER" and "TODAY" formulas
Hi Community, I am having a hard time getting my "WEEKNUMBER" and "TODAY" formulas to work and I am hoping someone can point out what my mistake is. I have created a metrics sheet to count the number of action items due over then next 6 weeks. I'd like the sheet to show rolling weeks ahead. For example: Current Week,…
-
How to automatically populate a cell with same info from another cell on the same row
Hello, First time SmartSheet Community Member! I have a sheet with specific rooms locations in separate columns. What I am trying to do is automatically populate the Room column with anything that’s populated in any of the Building Room columns to the right on that same row. I thought a VLOOKUP was the best to achieve…
-
Need help creating a custom duration formula
Hi! I need help with a formula to automatically update the "duration" column each day as well as only count weekdays and not weekends. Is this possible? Here is some more information. There is a "date submitted" column. A "status" column with three options: Not started, In progress, and Complete. There is a "duration"…
-
RYG - Checkbox/Age Group
Hello, I am having an issue with figuring out how to create a formula for RYG and checkbox columns. I have previously set this formula to be based on 'open' and 'completed' requests. Since this has changed we now have 'open', 'pending', 'at risk', and 'completed' requests. The formula, in the beginning, was based on 'open'…