-
Inputting Contacts into Smartsheets
Hi Smartsheet community, question..my Smartsheet account is not allowing me to input contacts of contractors for project into my inspection reports. I have the correct information for each contact (ie. email and phone number). Would this be a restriction out in place on my company’s end or..I need answers. Any feedback…
-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
automation emails being sent as a single email instead of multiple.
We have a sheet we use for Development Projects, sometimes people submit support tickets there that we want to be able to easily forward to our ticketing system, Service Now. I have an automation setup to trigger on a checkbox being checked that sends an email to our ticketing system, which creates a ticket. The trouble…
-
Automated notifications summary
Hi, Is there a way to generate a summary of all of the automated notifications that are sent from a sheet? Some users are receiving the automated reminders and others are not as we are testing. I'd like to find a way to verify that they are being sent as intended. Essentially, ensuring that the training due and overdue…
-
Email Alerts
I’ve noticed a discrepancy in my sheet's automated alerts. While the team is receiving notifications for all changes, I am only receiving alerts when others make modifications. I am not being notified of changes I make myself, despite the automation being set to alert for all updates. Could you help me check if there is a…
-
Function() or @argument for "currently logged in user" for use in Sheet formulas
I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user". This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person…
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
-
Smartsheet Automation Sheet Links and Bug Report
I had an automation that would copy rows to a duplicate sheet with test formulas / API connections. I moved this sheet to a new workspace with more limited permissions of other users, and the automation broke. I deleted and attempted to remake this Automation but searching the sheet name in the copy rows section it cannot…
-
Dynamic View Automate Update Request
How do I automate a dynamic view to send requests for updates? Trying to use/send the dynamic view only, not automate update requests from the within the parent sheet.
-
I need to pull certain data from a sheet to another with specific criteria such as (completion 0%)
I am trying to write a formula that allow me to pull certain data from another sheet with completion % 0 and with specific type/name. I need help with the formula