-
IF Statement to check a box
I feel like this is so simple but for some reason, I just can't figure it out!! I have a smartsheet where we're ranking applicants. They can get a highest score of 60. I have a column named "Rank" that has a formula in it that breaks them into Rank "1", Rank "2" or Rank "3" dependent on their final score. When "1" is…
-
Disable all automations
Hi, I have a lot of sheets that are not currently used. However there a lot of weekly automation sending alerts. Is there a way to disable all automations one one sheet at once or does each automaton have to be disabled manually?
-
Published Dashboards - CTRL+F availability
It would be very helpful for users to have the ability to search for keywords on published dashboards using CTRL+F. We use a published dashboard to provide all company help & information for Smartsheet. This helps showcase some of the functionality of Smartsheet from the start. We have multiple sections that we may refer…
-
Create Project in Resource Management from a Smartsheet Report
I would like to get data from a client's Smartsheet into Resource management, however their work is not formatted properly for me to be able to do so. In addition, there are rows of info that are not relevant to my team. I could make a report to pull the data I need, but I cannot create a project for Resource Management…
-
Record of workflow alerts
Smartsheet doesn't have a way to see if the email was sent, to whom the email was sent and what was the email that has been sent. We can only see when the workflow last run and work on blind faith that it actually was successful. Only to find out weeks later people aren't receiving the alerts, and there isn't a reason why…
-
User List report update: “Sheet (owned)” column changed to “Sheet (created)” column
Hi Community, Those of you who are SysAdmins may have worked with the User List report in the Smartsheet Admin Center before. Previously, the "Sheet (Owned)" column in the User List report would provide a count of the number of sheets owned by users in your organization. However, we are soon moving to a plan-level asset…
-
=COUNTIFS Function does not appear to work
Hi all, I am new to Smartsheets and would appreciate a little help. I have a sheet with a list of UAT defect reports within it and I am using a separate sheet to try to calculate various statistics. When trying to calculate how may defect reports are open for an individual I have used the following formula: =COUNTIFS({UAT…
-
Any current method to see all Automated workflows a specific person is named in?
If an employee moves on from a role and is replaced I need to switch all the automations they are named in to the new person. Right now multiple different sheet owners have to search though dozens and dozens of work flows across many sheets.
-
Why is my formula not returning a 1 for blank Priority column?
I am trying to create a formula for two columns Priority and Director Priority. If Director Priority is populated, I want the cell to return a 3 if High, a 2 if Medium, or a 1 if Low. If Director Priority is blank, I want the cell to return Priority. If the cell is returning Priority, I want the cell to return a 3 if High,…
-
Comparing Emails in different sheets
I am using Smartsheet, to collect data on some challenges that my department would like to conduct, and there will be four challenges a year (one for every months) for the participants who registers (registration is only once per participant) First sheet (Registration Sheet) collects the registration information via form…