-
Need help in formula function
I'm not able to get this formula to function in Smartsheet. The material ordered date is 9/3/2025. Am I missing something to get the date rage to populate? =TEXT([Material Ordered Date]@row +28,"MM/DD/YYYY")&"-"&TEXT([Material Ordered Date]@row +42, "MM/DD/YYYY")
-
Roll over Week Dates for a year
I am working on creating a sheet with the Week start date and end date in a column for the 52/53 weeeks of the year. Is there a forumla that rolls over the dates for me (December 30, 2024-January 5, 2025) Column.
-
SUMIFS Formula with Date Column
Hello All, I am using this formula " =SUMIFS({RCX- Kit Forecast - 2025 Range 1}, {RCX- Kit Forecast - 2025 Range 2}, ">=" + TODAY(), {RCX- Kit Forecast - 2025 Range 2}, "<=" + (TODAY() + 5)) " Range 1 is the number column Range 2 is a date column But the value is coming as zero
-
Compare Previous Week
Hello, I am trying to be able to say whether hours went up or down as compared to the previous week but am having trouble referencing the previous week. I have tried to add a helper column but am still getting an error. Any help would be greatly appreciated!
-
I am trying to find a value in a table based on 2 criteria.
I am trying to find a value in a table based on 2 criteria. One of the values is dynamic from a drop down menu, while the other is static value in a column. The first value is found in column "Building type" and the other is found in Resource type. The table I am referencing is also shown. The result would be shown in theā¦
-
Can you match a date from a drop down column?
Hi, I was trying to focus on preventing errors by added a list of very specific dates one can submit requests. I was hoping to have a drop down of dates to choose from. Then I have additional columns that will match that date selected and autofill the rest of the due dates from another sheet. If the user inputs the dateā¦
-
Adding the year into a formula
Good Morning, I am trying to add a year of 2025 into my below formula and for some reason how i thought it would go isnt working, any ideas: =COUNTIFS({BSA Audit Database Client}, [Primary Column]$1, {BSA Audit Database Date of audit}, MONTH(@cell ) = 8, {BSA Audit Database RAG}, RAG@row ) Thank you.
-
#BLOCKED / Auto-Save Issue in Project Billing Forecast Report
We are still facing a critical #BLOCKED / Invalid Value issue in our Project Billing Forecast Report. š Current behavior: In the underlying Sheets, formulas (e.g., Total Billed This Period, To Date Billed) initially show #BLOCKED/Invalid Value, then refresh to correct numbers. However, the Sheet does not auto-save thisā¦
-
Need help with a formula to look at multiple columns and insert a value in another column.
Currently I have the following formula in the Grant Status column to indicate active or inactive based on the end date. Now I need to add Deactivated as a status based on if the FY Start is NA. If NA is the value, then Grant Status needs to be deactivated regardless of what End Date is, whether blank or has any value.ā¦
-
Workflow to trigger comms when number exceeded but not in between.
Hi, trying to work out how I can get a workflow to trigger only when certain milestone numbers are met. For example, I'd like an email comm to be sent once the sum of a column reaches 50, 100, 150, 200 etc. The number will be entered via a form, very basic, so for example 4 entries could be sent via 4 form inputs (15, 11,ā¦