-
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…
-
Mark duplicate with cell linking
Hello! I am trying to check my helper column if a certain column contains any of the same amounts as in multiple columns in a sep sheet. I tried cell reference in place of [Column Name]@row but it isn't working... any help here? =IF(COUNTIF([Column Name]:[Column Name], [Column Name]@row) > 1, 1)
-
Overwriting lines
We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time. Anyone else experiencing these issues?
-
Smartsheet calendar fail to sync with Google Calendar
Hi Community, I'm a smartsheet beginner and hoping I can get some help here. When I follow the steps to publish a smartsheet calendar to Google calendar, the process seems smooth without any trouble. But somehow when I check my google calendar, there is just nothing. The smartsheet calendar didn't appear on the Google…
