-
Project sheet start/finish dates
Hi all, Pretty much all my projects work over weekends. I am trying to set deadlines for start or finishes that land on either a Saturday or a Sunday, however, the project template keeps defaulting the dates back to the Friday. Any suggestions? Cheers
-
Notification only when their name appears
We have A LOT of data we use smartsheet for and it is easy to miss something with our collaborators. I would like to be able to set notifications only when their name is assigned something and not when the entire column of "assigned" changes. Any way to do this?
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
-
Unwanted Scroll Bar in Sight
I recently built a sight (2 screen shots included below) and I'm wondering if anyone has come across this issue and if they know of a way to fix it. I have a report widget and for some reason I can't get rid of the scroll bar on the bottom. I would like it to be wide enough that it doesn't need a scroll bar, but, as seen…
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Blocking Exporting
Hi, Is there currently an option or setting to block a viewer from being able to export data? I cannot seem to find it. Thanks!
-
Issues with Smarthooks verification.
I am not sure if I understand smarthooks correctly or if smartsheet just made a "dumb" implementation. I can create a hook but verification failosm OF COURSE. It expected the url to send something special back (Smartsheet-Hook-Response: <sendID>). Unless this is not a generall webhook standard that bodes get echoes back,…
-
Filtering Calendar View
Is there a way to filter the calendar view to show more information (from other columns) rather than just the primary column information?
-
Basics of Webhooks from other applications via SurveyGizmo
Hi, I am new to attempting to work with these Webhooks and could use some help. I use SurveyGizmo as a surveying tool to gather information from a large amount of users. I am trying to build it to where everytime a response is made in SurveyGizmo, it will transmit that data to Smartsheet to store on a sheet. SurveyGizmo…
-
Help with formula to avoid #DIVIDE BYZERO ERROR message
Hello, I have a large formula trying to achieve an AverageIf function - but I still sometimes get the #Divide By Zero error - any ideas of what i can do to the formula to avoid this? =SUMIFS([HEP Time (Minutes)]:[HEP Time (Minutes)], [HEP Name]:[HEP Name], "Galvin Davidson", [Current Month]:[Current Month], 1,…