-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
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…
-
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…
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
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…
-
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…
-
Formula for Length of Day
I need to get the "Length of Day" that is set in Settings so that I can perform some time calculations on the Length of the Day set for the project. Is there a way to derive this?
-
Editing Reports Without Having Access to the Underlying Sheet?
For my solution it would be very convenient to share reports with edit rights without granting them for the underlying sheet. I was not able to achieve this, however, I may as well have tried it the wrong way. Any idea? Thanks and cheers
-
Export Report Calendar to Google Calendar
Good Afternoon, Reference: http://help.smartsheet.com/customer/portal/articles/518535-syncing-your-smartsheet-and-google-calendars It looks like you can export a sheet calendar (up to 600 rows) to a Google calendar but cannot export a report to a Google calendar. To address this, I copied the report data to a new…