-
Conditional formatting for dates that are X amount of time in the past
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another…
-
Prevent users unsubscribing from automation workflows
It should be possible to prevent users unsubscribing from workflows as these can form part of a process notifying users or work/tasks etc. These users have been setup, they have not subscribed so they should not be able to unsubscribe.
-
Update Sheet/Cell via e-mail
Is there a way that a cell/sheet can be updated from an email? In my search, some seemed to think that a sheet is related to a specific email address, that when emailed with the correct format to declare column/row/cell, the chosen contents would end up on the sheet itself. Is this possible?
-
Workflow not triggering emails for multiple rows
Hello, I have a grid that I am using to trigger emailing forms to other parties to collect data. I am using a Y/N field and a workflow to trigger the email. When "No" or "blank", nothing happens. When moved to "Yes", the workflow grabs a link from another cell and sends the email with the link to the form. This works fine…
-
Master Sheet with Thousands of Rows
Hi All! I have multiple sheets that are tied to specific team members on my team. Each sheet has the same columns. I'm currently trying to see if there's a better way to organize this data. Right now, 12 sheets are managed individually by each team member and then when a row is resolved, it gets moved to a "resolved"…
-
Form responses for a sheet that's no longer there....
Hello Not sure how to navigate this one. I am receiving form responses when people fill in a web form... but the sheet that it relates to is not in Smartsheet. I think it may have been deleted previously by a member of the team who has moved on. Is there any way of either recovering this file (it's not in my deleted items…
-
Entry date/Payments
I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in May. How do I make it so that the sheet won't calculate until the "entry date"?
-
Edited CONTACTS - flowing to other sheets
If I edit a contact in My Contacts (the Name portion, not the email), will that flow to everywhere the contact is used (all sheets)? It appears the answer is no, and it takes manually editing each instance of the contant on all individual sheets. Hoping this is not the case, or there's an easy solution or workaround.…
-
Recurring Tasks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
-
Create sheet with just 1 row per person
I'm trying to create a new sheet that only has one row per Instructor from a master sheet. I have a master sheet of Instructors for my program and it is being updated as Instructors apply to teach courses. I'm trying to create a new sheet with only one row per Instructor from this for a summary and to help with sending…