I have the following data in a sheet. I want to create a report (or anything that makes sense), that says if it is anything other than "Top Level", it will be tabbed over under the parent process it a…
Hello, I created an intake form for a project request. In the form there's a field where the submitter has to select from a dropdown list of Contract Information choices. Here are the automation logic…
Hi, I was wondering if there was a way to automate a report that could be emailed for all users who haven't logged into Smartsheets in an "x" amount of time. So for example, a report would run monthly…
I currently have a sheet that captures many fields of data, but not all of the fields are filled out every time and the same ones are not always consistently filled out. Is there a way to send an upda…
Hello- I have an access request form that needs to flow through two levels of approval. 1st level is the employee's supervisor, and they next is the director. The form keeps getting stuck if the super…
what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipm…
Hi Everyone - I'm trying to copy rows from one sheet to another with 3 conditions. The first is when the "CF Primary" checkbox column is checked. The second and third are if a project end date is grea…
Hello, I am having an issue with automated messages. The issue is the rows I selected to send are coming in via email with the background filled in a very dark color. It is very hard to read and will …
Has anyone else noticed this week the calendar option in workflows had changed from a Sunday through Saturday format to a Monday through Sunday format? I had a workflow that sent out a notification wh…