I would like to calculate the duration based on two tasks. For example, I want a start date from say task 1 to be the start date of Task 2, while the end date of Task 2, to be the start day of task 10…
Is there a way to validate a date before submitting a form. The Use-case is: We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We wa…
Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink…
For example if on a team I have 15 projects that are on going Assignment 1, 2, 3, 4 etc I want to assign primary, secondary , tertiary Then I want to have each person list how much time they spend a m…
Error message when trying to connect to Smartsheets remotely (this has only started happening the last few days). See the screen shots below. As smartsheets is in the cloud it does not seem correct th…
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number m…
Smartsheet community, I have tried smartsheet labs for the charts and have a live iframe to be embedded in the Dashboard but there is a no widget to include iframes. can we include this and do we have…
Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Mont…
Hello, Coming from a project planning background I am used to being able to chose how I group my plans. Is it possible in smartsheet to group say by who a task is assigned too? I understand the way th…