-
Trigger workflow
Hi there, I wanted to create if a field is updated/changed and a certain field is blank that it sends an alert. However, I want that to be daily just in case I forget. The workflow trigger, if I set it to daily is that how it will work? Thank you for your help in advance! Iris
-
Reoccurring / Repeating Tasks
Hello, I desperately need to set up reoccurring tasks, some monthly, some quarterly and some annually. Coming from Asana, this was super easy to do but it looks complicated here. I see a reoccurring task template but it is manually/formula based. Help! Not being able to do this easily might be a deal breaker :(
-
Is it possible to have a Report always query all grids within a folder?
For ease of workflow, I use "Closed" / "Active" folder structures for my projects, to keep organization/navigation simple and relevant to active projects. Currently, when building a report, you can click a folder to include all grids within the folder. It would be great if the report could retain the folder selection,…
-
Gantt View Timeline color coded by stages
I am looking to develop a Gantt view that shows multiple colors on a single bar, based on the calendar, and corresponding stage of the project at that time. For example: Project XYZ, single timeline: red during planning stage (Oct 7-14), green during live stage (Oct 15-22), yellow during results review (Oct 23-29), etc I…
-
Date format on dashboards
Although I can specify date format on a sheet in the ISO 8106 format, the date widget on the dashboard will only show the standard U.S. format. Is there a way to get the date on the dashboard to show in ISO 8106 for my European colleagues?
-
Update Request System Generated Form?
Hello all. I sent out update requests last week and most of the recipients had multiple line items to update. I was surprised to see an 'Open Form' icon in the message but even more surprised to find that when I clicked it, a form popped up with the name of the line item allowing me to enter the comments THEN to go to the…
-
Printing a filtered view from a view-only smartsheet
I have our project schedule posted on a contractor dashboard as a view only document for all our contractors to view. I set it up as a view-only document so they can't mess with it. I've published filters so each contractor can see only their scheduled tasks. I learned today that when you try to print this filtered view,…
-
Calendar App acting strange
Hi, Last week the calendar app looked great, today it's truncating and showing only a few entries. I don't get why, and I have to do a presentation on it today! So I need to figure this out ASAP. It also won't let me edit the setup, the choices are greyed out. Thanks for any ideas. This calendar was set up a couple of…
-
Automate the creation of a entry in another sheet depending on a status of a cell in the source.
I have a grid that contains products which may or maynot need to be shipped to another region, I need to be able to list the products that require shipping and be able to view the status and update as needed. Example below, shows the region the product is for, the date required to ge on site, flag if it is suppose to be…
-
Tracking Time
Hello, I am sure there isn't an easy way to accomplish this but thought I would pose the question. Is there a way to track the time an item has spent since it was submitted or last modified? Our TeleICU would like to have KPIs on items that take longer then 1 hour to complete as they move from submission, to nurse review…
