-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
Number of duplicates
Hello, I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names? Many thanks, Pltrmgrl
-
Automation - Any Changes when Price Greater Than
Hi - I am unable to get this automation to work. I would like to send a notification to someone when a row has any change made to the data (or comments & attachments) when the "JO Volume" is greater than $1,000,000. I have revised this workflow multiple ways, and I cannot get it to trigger a notification. Any idea what I…
-
Calendar comments in email notifications
We need comments to be displayed in the @ notifications in emails from comments added to the caledar. It would also be great if the related calendar cell info/comment can be opened via the email link instead of just going to the default calendar view. Without this feature it makes the calendar pretty much usesless for the…
-
How to change the date format in the "Last Modified" date column
does anyone know if it is possible to change the date formatting in the "Last Modified" date column. It currently shows up as month/day/year which is causing confusion as I work on a global team. Is there a way to make it 21Jul24 for example
-
Copying action while building Automation
Smartsheet should have option to copy a specific action and reuse it within the Automation. This will save a lot ot time of building Automation where repeative action needs to be places under different condition. Similar faicility is available in Microsoft Power Automate where user can copy some aciton and reuse the same…
-
New! Add real-time validation to fields on your form
Hi Community, We just enabled a forms enhancement that many of you have requested: field validation. You can now add real-time validation to Text/Number fields to help collect error-free numbers, percentages, email addresses, and phone numbers. Email validation is also available for Contact fields. We think this will be a…
-
Time and Date Calculation
Back to SLA calculations, this calculation worked in the previous wave of Hypercare, but for some reason isn't doing so now. Background: We calculate SLA based on Priority Critical=4, High=8, Medium=24, Low=48. Actual SLA tracks how long a Ticket remains open. I know I am missing something. =IF([Tracking Status]@row =…
-
Contact Grouping for Specific Sheets
It would be useful to be able to create a contact list for a specific sheet. This could then populate in the sheet when you create a contact column instead of needing to list contacts straight into the form to come up as a list. This would be useful when sharing a sheet (like a RACI) with someone else to populate.
-
Change default date format for the organization
The current default date format is MM/DD/YYYY for all sheets in Smartsheet. Many people in our organization dislike this format and opt to change the date format for individual sheets they are working on to be in a different format, such as DD/MM/YYYY or YYYY-MM-DD. The issue is that when different departments and teams…