I want to auto generate a receipt with Zapier or something and send it to the supervisor and client upon work completed. Problem: Our electricians perform tests on all equipment we install. We have ma…
Does anyone know how to alter the horizontal axis range? I have a chart that is displaying percentages but the horizontal axis maximum percent is set to 120% so pieces of the project are looking as th…
I have a report that compiles data from multiple Workspaces. I would like to be able to include the workspace in the report as a column (just like I can include Sheet Name as a column.) Is there at le…
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. H…
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 …
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 Act…
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 day…
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 vie…
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…