-
Nesting MIN and IF functions
Hi, guys! I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. To find the…
-
One Time Links for Update Requests
Is there a way around the ONE TIME Link, WE NEED THE UPDATE REQUEST LINK to stay active and allow more than one entry. This will allow the user to add notes / comments as they try to achieve the update and obtain the information
-
Approval Process - Ignoring Requests
Hello, I feel like I should know this (or be able to find it elsewhere in the community), but I cannot find the answer I need. (See screenshot) Basically, we have an approval process set up that works perfectly. As soon as HR submits a document, it is forwarded to Executive Approval. Once approved, it then auto-sends the…
-
Update Requests from Mobile
Why can't I send an Update Request from a row in the mobile app? I tap the row to open it to edit and I'm not able to send an Update Request. I'm on an iPhone, if that is important.
-
Daily Notification
Hi All, Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date, Red is overdue). What I would like to do is once the dot turns Red, to have a…
-
Update Requests 'Today'
Hi, I have a planned date column, and I would like to send out an update request to the contact column when the planned date is = to today. Is this possible? Thanks, Aaron
-
Creating Different Update Request Formats
I send update requests every day. However, when I send them, I have to keep removing some of the columns as those that I remove are not necessary for the person to see. Is there a way that I can save an update request format with those columns removed so I can quickly choose the right formats for the specific person I am…
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
What to do when project ends?
Hi Smartsheet Community, Our company works with customers on projects for a set period of time. When a project is complete, we archive completed projects for internal use, but we no longer need our customers to view or edit sheets and sights in Smartsheet. When a project ends, is there is way to inactivate or close our…
-
Send Update Request - Button not Hyperlinked in JIRA ticket
Hi All, I use Send update request to email alias that automatically creates a JIRA ticket. However the Open Update Form Button - is not linked in the JIRA ticket description ? Any ideas how I can get the Update Form button to open ?
