-
Latest Comment Column - Default Name Doesn't Include Last Name.
Hi, How can I get the name that appears in the "Latest Comment" column to match the name in the "Assigned To" column? I have a helper "yes or no" column with a formula. The formula is set to enter yes if the latest comment is NOT the person in the "assigned to". Then, I use this helper column for a notification automation.…
-
Can a weekly report not include information from last week?
I have scheduled an attachment to be sent via excel every week to the recipient. It includes information of terminations that need to be made. At the moment, in the sheet there is a checkbox that you tick when you want it to be terminated and a termination date that you include. What I am hoping to do is send a copy of the…
-
Is there a way to view the whole workspace activity log?
I am looking for ways to view changes that are being made in a workspace, like track new sheets made, who made them at what time, deleted sheets and dashboards, etc.
-
Admin Roles but Unlicensed
Will each user that I designate as Admin to a workspace/sheet use a license or can they be unlicensed? Do each of the users who submit data through an intake form need an account?
-
Task over due 3 days
How to make it to send an alert when the status is waiting on... and the task due date is over due by 3 days and it alerts the owner. It will only alert On the 3rd day and not all the days between the due date and 3 days past. Then an alert so that it notifies if it is 10 days in the past. The alert will only go out on the…
-
Start date for alert - send on the last Wednesday of every month
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…
-
Digitally Stamping an Attachment
I am looking to see if anyone has come up with a creative way to digitally stamp an attachment without having to download, open, stamp, save, and upload said attachment. We have an approval process that goes through multiple steps and the final step is a stamp. This is a timely process and I am looking for suggestions that…
-
Email address validation
We are sharing a Smartsheet with users across our company and are requesting that those users contribute different data on the Smartsheet. We have noticed that many have not responded and wondered if there was a way to confirm that a particular email is still valid? Is there a notification or something else similar to what…
-
Remove or Suppress Blank Rows in Report
Hello. I have a report that is displaying 15-20 rows of data (will never exceed 25 rows). The problem is that the report appears to default to showing 50 rows regardless of the data. As a result, in the current state, there will always be between 25 to 35 blank rows on this report. I am looking to use this report on a…
-
Fully customized automated emails
Is there a way to better customize automated emails? Backstory: We have an intake form where our users are able to enter a ticket for our team. We want to provide some transparency and a view to that request - status, priority, etc - without giving them access to the sheet itself because we have a ton of working columns…