-
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…
-
Update Webform URL's included in Folder when Save As New used
We are currently running multiple Projects and have setup a Master Folder with our Process Task lists in using Card View. Within Card View we have links to some Webforms used to capture Data for certain key tasks. The Webform sheets are located in the same folder. When we do Save As New using the Master Folder to Create a…
-
Best practices for incorporating human resources/work force for company with multiple divisions
I'm trying to find the best way to incorporate my companies career path/employee roles for mulitple projects throughout five divisions. Request the best practices for resource management for mulitple projects.
-
Check if cell is empty then join.....
Hello, Friends. New user who like Smartsheet very much. Situation: A general user provides input via the smartsheet form. Once the form is submitted, column B is populated by a Smartsheet number generator (next sequence number). Works great. I have built a JOIN which runs great manually. I would like to run the JOIN only…
-
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,…
-
Gantt Chart Child activity start date locked to parent start date..
Having a strange issue where I cannot change the start date of a child activity. It locks to the parent activity start date. Also if I try to add a new activity below the same parent, or if I create it somewhere else and move it to below the parent - it still locks it to to the parent start date. None of the activities…
-
Formula to automate Parent date
I can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item. It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the correct formula. EXAMPLE Parent Date | =last date entered below Child Date 1 | 1/3/17 Child…
-
Calculating lateness
I'd like to indicate when activities start slipping behind baseline start dates, using conditional formatting. To do this, however, I need to be able to calculate the difference between the Actual start date (entered manually) and the Baseline start date (locked). What is a formula to do this calculation?
-
Automatic hyperlinks disable
Could you please tell me if PASTE AS PLAIN TEXT or disable automatic link conversion (when pastes in a cell) will be done anytime in a near future? If it is not planned anytime soone 1-3month , then could you give me some directions on how I would be able to disable this feature with an app, or whatever else,code, whatever…
-
Is there a formula to check one checkbox for a row that will check other checkboxes throughout the s
I am creating a sheet that contains the same item on multiple rows and need a way to link the checkboxes, so if one is checked all are checked. Please help!