-
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…
-
Bug: Pasting from Excel with quotation marks fails to find end of row
Relevant xkcd Pasting a selection from Excel into Smartsheet fails to find the end of row if you include (1) double quotation mark ( " ). See below. As an example, pasting the data above from Excel to a Smartsheet grid produces the following result: It appears that Smartsheet is not catching and escaping these characters,…
-
Multi Select Column in Reports
I am using the new Multi Select Drop Down Column type, I have 2 options for check off in it. When I want to filter it in a report the check off items don't show up. I can find the column in the "What?" Section, I add it, but it will only let me filter it by "blank" not by the 2 options I have put it as check off fields in…