I created a Smartsheet for a team calendar. I created a Form attached to the Smartsheet for the team to request new "events" and be able to get them added to the calendar. Then, I created an Automation Process for Approval when "rows are added" and set it up to leave the row upon approval and delete the row upon rejection.…
Is there a formula/ methodology to auto number parent rows only, preferably with a prefix style numbering sequence like the Autonumber column type uses?
I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet. This works well.…
I have a sheet set up with cross-sheet references. The autonumber function is populating blank rows. Is this normal behavior?
I'm trying to figure out if/how I can return a checkbox column to it's original state once a user has completed scoping a project. I've tried just about everything and keep running into roadblocks given my level of Smartsheet knowledge. For context: I've created a project scoping sheet that contains rows for all…
We have a Smartsheet form set up where people can submit requests. On the form there is a question where they have to put their supervisor's email. Is there a way to automate sending a copy of their submittals to the supervisor email they input in that contact list/question in Smartsheet? I'm already aware you can automate…
Hello All, We will have one project that will have multiple locations (that has other information such as num of people, city, country, name etc...). Since we have one intake sheet and as the new project comes in, new rows gets created. Our current solution is to create just a separate location sheet where folks can go and…
I am trying to set an automation to alert a contact weekly that there have been changes to certain rows, essentially I want to avoid multiple alerts and just have them sent once a week with all rows that were changed but it is not allowing me and pops up with the error message "Workflow Timing Unavailable". Is this not…
Hello from Hamburg Germany, Unfortunately we receive the content in the email notification with the parent row illegible! On the other hand the email notification without the parent row is just perfect >> see the comparison 😏 How we can get the email notification with the parent row in the same style as the email…
One of our clients faced the challenge of their planning team constantly needing to check a shared Google sheet throughout the day. The process of reviewing the data multiple times and manually updating the schedule was time-consuming and prone to errors. Missing any crucial information could potentially disrupt their…
