-
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…
-
Adjusting Lane Width & Card Height in Card View
Hello! Is it possible to adjust the width of the lanes or the card "height" in Card View? I am currently working w/ 4 lanes and would love to adjust the width of each lane, thus allowing more detail to be shown. The ability to adjust the "height" of each card would be helpful as well...thanks!
-
Trying to do logic if first character is a number, IF(ISNUMBER(LEFT... seems to always result in FAL
I want to do some logic based on whether an entry starts with a number. I assumed `=IF(ISNUMBER(LEFT([Primary Column]1)), "Number", "No Number")` would have worked, but it seems to always return FALSE. What am I missing? (Also, does this forum not support tables or code formatting?) | Primary Column | Formula | Result |…