-
Creating a points sheet from a previous query (issues with formula/sheet referencing)
Hi Everyone I have kindly had an issue relating to scoring answers on a multi-select dropdown https://community.smartsheet.com/discussion/104030/subject-adding-weighting-points-to-answers-within-a-multi-select-dropdown#latest However due to the volume of questions I'm looking to include, I want to create a separate points…
-
How do you enter a long formula?
Hello, I have quite a long formula, I wrote it in Word... When I copy and paste, the cells used in the formula are not highlighted, so I think the program doesn't recognize them. Therefore, I am copying my formula by hand. However, when I am at about the second or third line and I click on a cell to use it in the formula,…
-
Status change with due date
I cannot get any of the formulas I try to work to update status based on pending end day. Red= < 30 days Yellow = < 60 days Green
-
Workday formula getting an unparseable error
I am trying to calculate the end dates of some milestones. I have a start date column, planned duration column, and end date column. I have holidays in a separate sheet called holiday idle days. Im using the formula below but there seems to be an error with it. Can anyone advise? =WORKDAY([@row]Start Date, [@row]Planned…
-
Automation Workflow run on the 1st of the month
Hi I need to have an automation run on the first of the month based on the approval date and I'm not sure how to do it. For example, if the approval date is done 5/8/23, then the automation should run on 6/1/23. I believe I need to create a helper column that would house the formula to calculate the 6/1/23 date but I'm not…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…
-
How do I "square" a formula
This is the excel formula which includes to square the equation and then multiply (last 2 functions). This is an invalid operation in Smartsheet (^)... how can I make this work? =IF(ISBLANK([Operator Height]@row), "", IF([Operator Height]@row = 0, 0, IF([Operator Repeat]@row = 0, 0, [Operator Height]@row / [32/64]@row /…
-
Count # of Dates in a Cell - Minus Cells with Regular Text
Hello, I'm trying to figure out the formula that counts all cells in a column with a date. However, I have some cells with "NA" and I would like to exclude that from the count. Thank you so much for your help!
-
Fiscal year
Hi, Can anyone help me with this? I need to automatically record the fiscal month of a product based on its Offline Date, which indicates the month it is due. Our budget years are from October =IF(MONTH([Offline Date]@row)=> 10, "Fiscal Year " & (YEAR([Offline Date]@row) + 1), "Fiscal Year " & YEAR([Offline Date]@row))…
-
Multiple contacts selected to a task - calculating costs of effort
Hi, I have hourly rates for employees that are in the contact list. I calculate the costs of tasks assigned to a single contract with with no problem. However where multiple contact are assigned I cannot find a way to split out the contacts selected to then allow me to calculate their costs at individual rates Fred £10 per…
