Trending in Smartsheet Basics
-
Conditionally Copy "Modified By" value to another row cell
An update to a column called, "FOO", should trigger an event where the contents of "Modified By" are copied to a column called, "BAR". Steps. 1. I change the contents for "FOO" from 'a' to 'b'. 2. "Modified By' changes to my email (the usual automated way) 3. My email is copied over to "BAR" **If a field other than "FOO"…
-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
-
Summarize Data from a Report Column
Hi, I am attempting to summarize data in a report and I'm getting stuck. My intention is to summarise the milestone status of various projects that fall in year 2025 and display them on a dashboard. So far, I've managed to create a row report from various sheets (Project Plans), and filter for deadlines falling in 2025 for…