-
Why are my durations not calculating correctly, and how can I adjust this?
I'm working through a rather complicated column formula and ran into something that seems to be native to SmartSheet. It appears to be rather minor, but is throwing the whole thing off for me. If you look at the first row that has dates in it, for example, you'll see that the row starts on the 1st and lasts 10 working…
-
Is Store # present in list?
I have a survey that is to be completed by a set # of store locations (896 locations). I have a formula that will check the worksheet containing the survey inputs for store #. If Store # is absent then checkbox is checked. I want to built a lookup such that if you enter a Store # the result will either be; 'Survey has been…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
Quickly add columns for dates
Looking for help, is there a way I can quickly create a block of columns for month/date columns:
-
FY Q1-Q2-Q3-Q4
Hello there, looking for some feedback. I currently have this formula to identify FYQ. My FY goes from October-Sept. =IF(ISDATE([Referral Date]@row ) = false, "", IF(AND(YEAR([Referral Date]@row ) >= 2024, YEAR([Referral Date]@row ) <= 2025), IF(OR(MONTH([Referral Date]@row ) = 11, MONTH([Referral Date]@row ) = 12,…
-
Referencing another sheet to have automated assigning of files
I have attempted, several times, to follow the exact formula provided on AI so that I can assign new rows to random users. The AI formula showed: =IFERROR(INDEX({Team Sheet Names}, MATCH(MOD([Row ID]@row , MAX({Team Sheet Order})) + 1, {Team Sheet Order}, 0))) Following the directions and making the sheet reference, I…
-
How do I check an entire column for a particular value and only display the lowest example of it?
The question title is kind of confusing, so here's what I'm looking to find out. I'm making a Project Plan sheet, and want to have a place that updates the estimated completion date based on how the project has progressed thus far. There are more columns in my sheet, but my question is only related to the ones in the…
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
HAS function help
This discussion was created from comments split from: Ready Status Solved - I hope this helps everyone.
-
Can you copy / export workflows, conditional formatting and saved filters to other worksheet
We stated using Smartsheet back in November and I have a few active Smartsheet for projects and more we use it the more I find things I want to do across all sheets. If I add a workflow, conditional formation or saved filters to a sheet is there a way to export them and import them into another sheet? I know I can use a…