-
Activity Log
I have a question about the activity log. I had a user sort a really large file (2K rows) with child rows so not fun to fix as you can imagine. When I check the activity log it says the did it from an "unknown" source.. Just try to help educate them but hard to figure out how they did it if it says they weren't even in the…
-
Multiple IF Statements
Hello! Working on an formula where the Status will indicate the Health. Complete = Green, In Progress = Yellow, Not Started = Gray, and On Hold = Red. This formula works: =IF((Status@row) = “Complete”, "Green”) And according to other articles I read here, multiple IF statements can be linked together by commas (some have…
-
Can a non-licensed user update a dashboard
What can a non-licensed user with admin rights do when they are in charge of maintaining a current dashboard?
-
#INVALID COLUMN VALUE Error with Max() Function
Hi All, I'm was trying to use the Max() function to grab the latest date in a supporting sheet. From reading it looks like this is a valid use of the function. The sheet being referenced is set as a date field in properties. I'm basically building a small sheet to feed the latest daily balances on some company bank…
-
Make fields read-only and route the form to appropriate person
Hello, I have set up a form with multiple fields and based on the value of a field, the form displays a set of fields. I am trying to see if there is an option to make such fields read-only depends on what value is selected? For example, I have a selection field called 'Define yourself' with two values 'Business' and 'IT'.…
-
Feature request: ability to edit and link to sheet cells from a Dashboard
Hi! Following up on this feature request, we would also like to request the ability to edit cells from a Dashboard and well as linking to them. Our use case is simple: our team uses dashboards for individual task and team management, and the ability to do quick edits and link to that specific row from a Dashboard would…
-
On-demand Webinar: Upgrade Your Dashboards with a New Look, Custom Colors, & More
Webinar Recording: Upgrade Your Dashboards with a New Look, Custom Colors, & More. In this webinar, we’ll share how to upgrade your dashboards to our new modern design, featuring custom colors, widget editor, and menus. New to Smartsheet? SmartStart Onboarding is offered weekly - register at smartsheet.com/webinars.
-
Data from Activity Log
Hello, Is there a way to take the data from my sheet's Activity Log and use it to populate a Smartsheet Dashboard? I do not want to manually export it to Excel. When creating a Smartsheet Dashboard and you click --> Add Widget --> Chart. It asks you to select a sheet to populate your chart. Can we have a chart populated by…
-
Forms 2 part Question
Ive created a form but every time my user attempts to add a record, it adds additional blank rows to my master sheet. Also when they are successfully adding a record sometimes it throws the new record about 100 lines below the last row used. Has anyone had this problem and any idea how to fix?
-
Send alert when an attachement is added on the sheet level
Hello everyone Do you know if it is possible to add an automation workflow when a new attachement is added directly on the sheet level and not on a specific row ? Thank you for your time, have a nice day, Corentin