-
Feature Request - Comments and Attachments trigger 'modified' column value
I'm trying to create reports that will show my projects the changes to their workspaces over the past day. I thought a report would do the trick, and I'd just filter by modified within the last day. However, reports don't always catch what you're looking for, like ALL the changes. Report WARNING, the "modified" system…
-
Last Modify Date based on Comments
I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.
-
Trigger Report Due when month changes from modified date
Hi I have a basic text entry sheet for a dashboard report. Fields are: [Subject], [Details], [Modified], [Due] In the [Due] Column I want to show that the month has changed so I can trigger an update request. How would I go about doing this? Regards Steve
-
How to add a Red Flag when there is an entry more than once in last 12 months
Hi, I have a table which records driving infringements. What I want to be able to do is have a function determine if a driver has had more than one infringement in the last 12 months. Then use the Actions and Alerts to notify their manager. But need the function to work first before I can do that. I know how to use the…
-
Raise flag if due date is within 30 days
Hi There I'm very new to smartsheet so for you this might be a very simple thing. I'll appreciate if someone let me know what'd be the formula if I want to raise a flag whenever the due date is 30 days from the current date. We'll appreciate your help. Thanks Raashid K
-
Card View is great for sheets. Please bring to reports, too.
Love Card View! I can definitely see using it. My issue is that I do almost all of my viewing in Reports as opposed to Sheets because I work across many sheets for my work, consildated into Report views. I know there might be complications to implementing this, for example when a sheet included in report does not have a…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
How to Create Tend Arrows with a Function
I have a cross sheet table with data displayed on it that works fine. Just wondering how I can display a trend arrow using a function for Up, Down and Across. Basically, I am measuring KPI performance against the number of days since the last time we had for example a Lost Time Injury or as is known as an LTI. This work…
-
Contact Columns not available in POwerBI when multiple contact enabled?
Whenever I enable a contact list to allow multiple contacts (New feature Oct 2018); the power BI column display balnk for all records. Happens after enabling this in the columns and adding multiple contacts in any cell.
-
Using Trend Arrows
I have a formula which works out the Net Days since an event occurred. I have the following: [Event Type], [Days Since Last Event], [Day Before], [Trend] The [Event Type] is the event I am searching for the number of days since the last one occurred. The Number of days appears in [Days Since Last Event], is a formula which…