Best Of
Re: More fun with functions =IF(OR
Hi @Draykov ,
I have added in the OR syntax for "Humanities" as in your example.
=IF(OR([Teaching Discipline]@row = "English", [Teaching Discipline]@row = "Humanities"), "AA", IF([Teaching Discipline]@row = "Art", "BB", IF([Teaching Discipline]@row = "Philosophy", "CC", IF([Teaching Discipline]@row = "Business", "DD", IF([Teaching Discipline]@row = "Accounting", "EE", IF([Teaching Discipline]@row = "Government", "FF", IF([Teaching Discipline]@row = "History", "GG", IF([Teaching Discipline]@row = "Anthropology", "HH", IF([Teaching Discipline]@row = "Mathematics", "II", IF([Teaching Discipline]@row = "Biology", "JJ", IF([Teaching Discipline]@row = "Geology", "KK", IF([Teaching Discipline]@row = "Computer Science", "LL"))))))))))))
If you follow the same structure, you can add to any of the other IF scenarios you need.
Hope this helps,
Dave
DKazatsky2
Re: Basic copy/paste function
I regularly do all three of those. You may need to reach out to Support to see if there is a bug somewhere.
Paul Newcome
Re: Contact Upload Feature No Longer Working
If Google Sheets isn't an option, opening the .csv in Notepad and saving before importing also works.
BaggLunch
Re: A way to place the Row ID (for APIs) into a cell value with formula?
Hi @KGuyer ,
There isn't currently a specific function that returns the rowID. When you have a moment, please let our Product team know about your feedback by filling in this form, here. Thank you!
As @MattW mentions, a possible way to automate this would be to use a third party tool that uses the API to return all rowIDs within a sheet (by making a GET sheet call for example) and then collect the rowIDs and post them back within the sheet as needed. I'd refer to https://smartsheet.redoc.ly/tag/sheets#operation/getSheet from the API documentation if this sounds like a possible solution.
The other way to obtain the rowID would be to manually collect it from the row properties and paste it to the relevant cell but I understand this can be a tedious task in voluminous sheets.
I hope this can be of help.
Cheers!
Julio
Julio S.
Auto Generate Task List based on Criteria
I am wondering if there is a way to trigger a task list to start when criteria is met?
The task list is built and made into a template. I am wanting to trigger the activation or start and rename of this when the contract column in my schedule is changed to NTP. The file name would change to my Job Code which would be @row. Then the task template needs one date based off job start@row to activate all tasks.
Is this a possibility?
Caleb W
Re: Add Months to Date formula?
Slight edit added...
Dealing with months is somewhat tricky.
"How" do you want to add the months? Here are a few examples of ways to deal with months:
With a start date of 01/31/2024 and adding one month... simply incrementing the month will give you 02/31/2024, which is obviously not possible.
The average month length is 30.4375 days (factoring in leap years as well). This can be rounded down to 30 days. A start date of 01/31/2024 and adding 40 months (40 x 30 = 1200) will return 04/15/2027 as a result. Mathematically this makes sense, logically you would expect the result to land in May. I believe Smartsheet essentially does this in the background so it is the easiest to implement.
Going back to our first example (Starting on 01/31/2024 and adding one month), we could approach this a couple of different ways. We can say that any result that lands on an "impossible" day just gets "pulled back" to the last valid day of the month. So 01/31/2024 + 1 month would return 02/29/2024 (leap year).
The other option is to have it roll over to the first day of the following month. 01/31/2024 + 1 month = 03/01/2024.
How you would prefer to handle the result will dictate how to approach this.
Carson Penticuff
Re: Can automation create a new sheet from a template?
You can automate the initiation from the Approval column, however optional items will be skipped and it will only include required items.
Cheers,
Genevieve
Genevieve P.
Re: Column Dividers in a Sheet
Hi @Kendra P,
I use the same thing; formatted columns as dividers. One thing is you have to use a different name for each one.
Sometimes I use a period for my first, and 2 periods for my second.
Sometimes I name the column separators which helps when scrolling through many columns. It's like column group headers, but as columns instead of headers.
I don't believe there's any other option to separate out sections of columns (like in Excel).
Would make for a good Product Idea to submit though!
BRgds,
-Ray
Ray Lindstrom
Re: NEW! Dashboard Builder Enhancements
All great stuff. Now if we could just get something into the mix regarding automation to send out a published dashboard via email on a scheduled cadence, we’d be in really great shape.
Steve Robinette
Re: NEW! Dashboard Builder Enhancements
Id really like to see the ability to have filters. currently dashboards with multiple facility builds is not UX friendly or build friendly.
Willlybolt