-
Add to Calendar for event registration
We are currently using Smartsheet to build reusable templates for events that occur multiple times a year and will continue for years to come. One frustrating thing that Smartsheet is lacking, is the add to calendar feature. Adding this feature would allow users to include the zoom, teams, or whatever meeting platform they…
-
Why is my formula unparseable?
=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A") The bold is what I want to subtract within the formula.
-
When a form is submitted I want to add 3 children task underneath each request
Hi, How can I achieve when a request is submitted I want to add 3 children task underneath it. so that when ever the request is submitted I have predefined user task(repetetive same)task that needs to be completed Thank you in Advance. Thanks, Radhika
-
"When Triggered" Automations Behaviour
A colleague of mine has sent me a question that has stumped me and has got me thinking my understanding of how automations work has been wrong. She sent me the following: We have automations that are set up to send when triggered that send emails to support when someone requests access to one of our products and also a…
-
Who can create new sheets
I wanted to confirm. As the only licensed user at my organization, I will need to create and then share sheets with all other users here? They can edit and add to a sheet but cannot make a new one themselves? Including they cannot copy to new a template? EDIT( to clarify we have a business level account)
-
Moved Project into another folder and it messed up formulas within project meta sheet
Good Morning, I created additional folders to organize project folders but it seemed to mess up formulas within my project meta sheet and gave the following two error codes in some sections; #BLOCKED and #INVALID REF. When I clicked into what sheet is being used as a reference it did not show an error within that sheet. I…
-
Formula Help: How to exclude past dates with MIN formula?
I am not good with formulas and haven't been able to figure this one out with usual troubleshooting... I am using the following formula to return the next upcoming Review Date (screenshots of use below). =MIN([Next Review Date]27:[Next Review Date]30) But I want to make it so that it doesn't include dates that are in the…
-
Mandatory Comment on Approval Form.
Hello, How can we make the comment section in the Approval Form mandatory? like it is mandatory no matter what.
-
Need help with a formula to sum all numbers in a column that have the same date?
Hi there -- I'm working on a project where I need to track the total number of hours a person worked each day. A person may have three rows (log entries) with the same date, so I'd like the formula to count the hours column for each row that has the same date. In the example above, the Total column would show the total…
-
Sheet - set a cell default
The ability to have a default value in a cell for a new row. Currently can only do this when the new row is being entered with a form
