-
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 |…
-
Help with a Formula
I have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing dates). I've included the formula below that returns the result of what your target %…
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
NEW ZEALAND TIME ZONE & TODAY() function mismatch
Hi Smartsheet Team , I have an issue with the Today() function not reading my date correctly . I contacted you and you provided me with a long formula to overcome this but it still didn't solve the issue for us . The formula i'm using now is : =IFERROR(IF(AND(ISBLANK([Resolved Date]@row), [Created Date]@row <= TODAY()),…
-
Approval Request after a modification
We are working with an approval workflow. In this approval flow the user has the possibility to change important things in the approval request. Problem: approval request is already sent We solved this by generating a new approval request when something in the request has changed. Problem: the persons who gets the approval…
-
#INVALID DATA TYPE when using COUNTIF Formula
Hey Community - I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet. All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID…
