- 添加小部件在我Dasboard“接触”
Hello, I'm a starter in Smartsheet and try to build a Dasboard for FM KPIs in a Building. I also want to add a widget that displays the building managers (with picture, role, and contactdata - max. 2 Persons). Enclosed you find two pics I found on other Dashboards. Witch widgets where used therefore? Or what do I have to…
- how to delete multiple unaccepted invitations?
Hello, I have a question about user management I would like to delete 50 unaccepted invitations. Line by line is long. Is it possible to do it all at once? Thanks
- "Rows deleted" no longer a trigger option. How can I track deletions?
When setting up a workflow to alert someone, I no longer see the trigger option of "when rows are deleted". How can I receive notification of this action?
- Amount of Requests per Lawyer
Hello, I'm trying to find out how many requests a lawyer gets per month based on a few things: -AFID (Auto Fill-In Date) -Type of Request = FOIA -Lawyer's Staff name -Status (Red, Yellow, Green, Blue; However, these are not in as words, they're in as "Visual Symbols") This is what I have right now (changing name for…
- Update Date when Health Changes
Hi All, I've been tasked with finding a way to automate a column in a health-tracker for our PMO. Here is the ask: "When [Health]@row changes to Any Value (red/yellow/green/grey), update the [Date of Change]@row with the date the change occured" Simply, we need a way to automatically track what day the change in health…
- Color Coding In Progress Tasks within a Specific Time Period in Gantt Chart
Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional formatting to fill the cell background of tasks with specific start and complete…
- Formula to show if certain cells are blank change the status to red, yellow, or green
I have a sheet where we want to show if the columns successor 1, 2, and 3 are blank the status column should be red. If only successor 1 is filled out status should be yellow If successor 1 and 2 are filled out staus should also be yellow If all 3 successor columns are filled out the status should be green. Pretty much…
- Indicating Each Month A Project Is Active?
Community, I'm struggling to indicate which months a project is active given a project start and end date. If a project starts on 09 January 2020 and ends on 09 March 2020, it would be active January, February, March. I would like to represent this as follows: Showing that the project was active in its Start Month and End…
- Update Dashboard Through API
Is there any talk for the potential to update sights using the API (other than renaming the dashboard)? We are using the API to copy everything in a folder to a new folder, but want to be able to update the embedded map we have on the dashboard using an address in the body of a POST.
- 'Editor - Can Share' users cannot run reports?
I started my new position and am the new Admin for Smartsheet at my work. We converted the Workspace permissions for the owner to 'Owner' and me to 'Admin' and everyone else in our office to 'Editor - Can Share'. For some reason, nobody can use the Report Builder to run a report unless I share that sheet with them and give…
