-
#BLOCKED
I have used the following formula in a few of my sheets, and it usually works. But sometimes I get a Blocked Error - can someone interpret the problem for me? =IF(NOT(ISBLANK([Closed Date]@row)), "Closed", IF(AND([Due Date]@row < [Todays Date]#, NOT(ISBLANK([Due Date]@row))), "Overdue", "Open"))
-
Automated reminder for an approval request
I have a process for requesting approval that requires approval from 5 different people. Once the first person approves, the request is forwarded to the next person. How can I set up automated reminders for each approver if the status remains "submitted" for more than 3 days?
-
How can i calculate the % Complete at a sub-parent level based on multiple criteria?
Hello and thanks in advance for any assistance. I have spent a ton of time attempting to solve and am tossing up the flag. I have a sheet that needs minimal column formulas due to the line/cell count potentially hitting the base reference limits. I have an overall % complete being calculated on the sheet itself already.…
-
How to find % of events that meet specific conditions within certain time window
In my Smartsheet, I have a column for Total # of Events Per Month. I am trying to find a way to calculate the Percent Events Closed Per Month. For the first part, I'm trying to calculate the # of events closed per month. Each row has a month start date & end date listed. Events that are closed have a "Conclusion" drop down…
-
ISNUMBER Formula Help
I have a sheet that has an INDEX look ups from another sheet for one of the look up Row (Target Install Start Date) will either have a Date or Text. In a new row I want to either use the date in a formal or just the text. I've done this in excel with =IF(ISNUMBER(G2),(G2+H2)-1,G2) but when I try to do this in Smartsheet…
-
If more than value,Submit, if less No
=IF(Total score]@row > 2, [Executive Sponsor Approval]1 = "No"), "Yes", "Submit"), Executive Sponsor Approval)) Hello, I am new to formula writing. Can someone help me write a formula where If total score >=3, then change Executive Sponsor to Submit and if not, then change Executive Sponsor to No. I will have an approval…
-
Can't Set Column Formula for Duration - Work Around Available?
I have several sheets that are tracking the time a field employee is working at a specific location. This is determined by the Current Date minus Start Date to give me the number of days. I set the output column to be a Duration column so that it would automatically input the "d" at the end. For my purposes, this needs to…
-
Adding Parent and Children Rows and need a blank response if result is 0
I am using the following formula to add the child and parent rows. However, it does not pertain to all cells in that column, but I want the formula to populate with each row added. How can I make the result blank if the response is 0? =SUM(CHILDREN([# of Lots]@row), [# of Lots]@row)
-
#UNPARSEABLE for Column "IF" Formula
I get an #UNPARSEABLE error for the following formula and am not sure what I'm doing wrong: =if([Destination]@row] = [Source]@row, [Destination ID #]@row, "") Where the destination = source, the destination ID should be entered. Otherwise, I want to leave the cell blank so that someone can manually enter the ID #.
-
Formula Help with IF ISBLANK and TODAY...
=IF(ISBLANK[Date Filled]@row), [Date of Vacancy]@row - Today@row, [Date Filled]@row-[Date of Vacancy]@row) I keep getting the #UNPARSEABLE error and I can't seem to figure out why. Any help would be greatly appreciated.