-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Renaming of attachments?
Good morning, I did a search in the Community, so apologies if this has already been addressed. Is there a simple way to rename attachments? We have several Word/PDF attachments and need to rename them to our internal naming convention protocol. The only way we've found is to download the document, rename, upload and then…
-
Enhancement Request: Group Columns
Would really like to see an option to group or at the very least hide columns. Would definitely allow for an easier view for columns with =sum functions but still provide options to open up the details if needed.
-
Single-Use Checkbox (or dropdown) - Can it be done?
Hi all! I looked in the forums and I didn't come upon any which matched this - but if you're aware of a similar thread, please link to it here! We are looking to find a way to make a checkbox or dropdown option a single-use type thing. Basically - we track travel in a large sheet - and part of the information we collect…
-
LOST WORK
APPARENTLY AUTOSAVE HAS CHANGED WITH THE NEW UI. I JUST LOST A LOT OF WORK EXPECTING IT TO WORK THE SAME. THANKS SMARTSHEET. Be careful out there users.
-
Saving eMail History
Only solution found: - cc myself on all email requests; this does not create/manage history well - create email as a discussion; save, then send that discussion Is it possible to save email's sent via smartsheets as part of the discussion for that line item?
-
UI "Enhancements"
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The additional clicks necessary to access "active" sheets for the day is almost exhausting. While I certainly hope Smartsheet…
-
UI "Improvements"
Hello Smartsheet Community- Last month Smartsheet released a new User Interface. This forum is FILLED with very concerned users who strongly feel these changes are not beneficial and they want the old Smartsheet tabs and navigation back. If you are one of these users, PLEASE keep asking smartsheet for updates on if the old…
-
Auto notification. When attachment downloaded
Hi. - I run a sheet with form to collate drawing data. the original form user uploads a drawing and this populates the sheet. the auto alert tells the other client (via email) of an attachment available for download. The client then downloads the attachment. Is there an auto alert to advise me - admin -that the attachment…