-
Track changes in Dashboards
Hi, Provided that I am "viewer" to a Dashboard item, any way I can track changes to the Dashboard(including the attached Sheet, attached files, attached item,etc)? Thanks. Ben
-
Image in Dashboard
I am working on a template for my dashboard that would show an image of the project in the top right corner. Now this image will change for each project. The goals is to have some of the data for the dashboard pulled from a Metric Sheet, I have added the image to a cell there and figured I could use the Metric widget to…
-
Prioritising responses
Hi SS guru's! I'm looking to create a dashboard that essentially visualises a list in priority order, based on the time we receieve a form response. So far I have a sheet where responses are logged, and we use system generated modified (date) to log the date and time we recieved the confirmation. What I want to do is…
-
Risk Register - download example template
Hi - I am trying to download the very first risk register template that is referenced on this page. https://www.smartsheet.com/risk-register-templates When I click the Smartsheet version, I get a completely different Risk Register. When I select Excel, I get the one pictured. I tried to download the Excel version and they…
-
January Week 1 2020 dates
I'm seeking a formula to save me time entering the dates for each week of the year So, the first cell in the row under my parent row (header row):January 2020, would say: "Week 1: 1/6 - 1/10" This would be produced automatically by the formula. This would be a level 2 parent. The children would be my tasks. Then I would…
-
Inconsistent Date Options
Hi I recently came across 2 date-related options which look inconsistent within the app. Would be grateful if the smartsheet development team can address it soonest! The Inconsistency: In the Workflow-Automation we can set a Condition as <any date field> is not today; whereas in the Conditional Formatting dialog, we don't…
-
Formula Issues
Hi Everyone, I am trying to enter the formula =NETDAYS([Date Submitted]294, [Pre-Site Survey Request Date]294). I receive an amount as long as there is a date in the columns. However, if one of the cells is blank I receive the #INVALID DATA TYPE error. How can I get the =NETDAYS to return a zero if one of the cells is…
-
Trying to Count multiple text by referring from another sheet
I want to count multiple values from a cells which are separated by ";" from a column. Can it be achieved by COLLECT/FIND/COUNTIF ? The following screen shots has the Info & expected output . Any suggestions please.
-
Automation update request failed to work
Hi There It’s several days the I’m trying to create an automatic workflow without success. Flow explanation: I want smart sheet will sent an daily request to person (wrote in contact List…) to fill specifics cells in case it’s Blank. It’s look very simple but unfortunately it doesn’t work for me. I’m really thanks for…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
