-
Help with a NETDAYS formula
I have a formula in my sheet that is counting the days of an assignment since it was assigned. I would like it to stop counting once the row is marked complete or a date of completion is added. For example, in the screenshot below, the 37 in row 4 should be a 36 since the "Date Completed" column is filled in and/or the…
-
Automate Trigger Slack DM's based on assignee email addresses in Smartsheet
It would be phenomenal if we could trigger messages to DM's or Ephemereal messages from Slackbot or the Smartsheet Slack App using some connection between the user's email in Smartsheet and the same email in Slack. This would allow users to be notified individually of changes or needs without having to alert the whole…
-
Indenting Rows automatically
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 aligns to. Parent Process "1 - Process Details Test" aligns with Process Identifier 1. I am hoping to have this automated.…
-
Automation works correctly when manually changed in sheet but not when input through form
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 I have: When I tested it by selecting the different options in the dropdown in the sheet column, this works correctly.…
-
Merged: Move/Add row automation: The ability to choose if the row populates at the top or bottom of…
This discussion has been merged.
-
Automate a report for user inactivity
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 and email me all users who last logged in over 3 months. Any information is greatly appreciated.
-
Can I set up an update or approval request using only cells that contain data?
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 update and/or approval request where it includes only fields that contain data? Currently, the email received and…
-
Form Automation- Request an Update
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 supervisor denies requests an update. the update form will send to the employee to update and submit. Once they resubmit the form…
-
Vlookup
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 {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
-
Sheet Automation with 3 conditions only respecting 1
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 greater than 12/31/23, OR if the project end date column is blank. The rows that are getting copied over are only those that…