-
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…
-
How do I stop a time-based reminder once an action has been completed?
Hi, I'm using a Form to pull information about different tasks and using time-triggered reminders for recipients until the task is completed. I want to avoid continued reminders after the task has been completed by using an automation to cancel the reminder, but haven't found a workable solution so far. Any ideas on how to…
-
Return the last value or latest value for a specified product
Hi, I am trying to return the most recent value for any part description Vlookup always gets the first one, any idea on how to 99 from the example below without sorting the data .. as the rows will be added automatically to this sheet from another sheet and they always go to the bottom row Thank you
-
Sumif Formula Question
I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get…
