-
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…
-
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
-
WorkFlow with a Report Form
I have reporting into a Register working just fine now. Now I need to send out another report based on an item that has occurred within the main register. i.e. A New Hazard has been reported. The report populates the main register but some items need to be worked on and this is typically carried out by a manager. Their…