-
Activity Log should reflect all changes made to a sheet (in detail) including Workflows
As of today, the activity log doesn't represent all of the activities undertaken on the sheet. For example, if a row hierarchy or conditional formatting has changed, columns formatted/hidden/unhidden or removed, it won't show up on the activity log in detail. This is difficult when we are trying to investigate the root…
-
Save Automations as Draft
There's been a few times now that I started creating an automation and it wasn't able to find the thing I wanted to reference or there was a minor issue with a reference and I had to completely discard the automation, go make my change, and then go and start creating the automation from scratch again. There is currently a…
-
Create groups of widgets on dashboards
It would be very helpful for us if we could create "groups" of widgets on dashboards, and allow actions to be taken on a group. I'm thinking this would be similar to how grouping works in the microsoft projects. First you select all the widgets you want in the group, then you select an option to group them. Our primary use…
-
Problem with Formulas module (self-paced learning)
Hi, I'm trying to walk through this and have run into a few issues. Sometimes I can't type where the instructions tell me to (usually adding characters to a formula). Then I'm forced to advance and I miss the rest of the lesson. Ideas? Suggestions? I plan to take the instructor led training but it would be nice to do the…
-
Hi, I’m unable to fill out the Smartsheet form. Please find the attached screenshots.
-
Nested
Hi All I am trying a nested index match - the index match and + "" text part work - but i wanted to add a twist - so when the information requested returned - only when 09-Mobilised does it become unchangeable (+ "") cant get it to work though - i want the status to change UNTIl it reached the 09-Mobilised status then to…
-
Formula for SUMIF all orders within last 90 days
I have an order sheet where individuals can order items, but we have a restriction that they can only order 5 "coupons" in a 90 day period. I need a "Block Order" box to be checked on the row if The order is > 5 "coupons" OR If the individual ordering has ordered > 5 "coupons" over the last 90 days (may be in multiple…
-
Parent/Children row date automation
I'm looking for some help with a possible parent/child formula. We have a parent row that lists the project name, then two date columns - start date and end date. The children rows list the tasks that have to be completed for the project. Each of the tasks will have a different start date and end date. The Foreman is…
-
Microsoft Causing Issues?
Hello, my company uses Microsoft office, so outlook is our email platform. Is that why my auto emails aren't sending from my smartsheet? I have them on my registration page, I click "ready to send" then save and it's supposed to auto send the invite/start the registration process. It's been working all week and last week…
-
Sheet Editor rights
Hi everyone, I am on a Pro plan and have Admin right. I wanted to share my sheet with a colleague and give them edit rights. When I shared with them, Smartsheet told me that non Members will only have Viewer rights. However, when I shared it did allow me to select "Editor" and my colleague is also able to make edits. So…