-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Show Value Sum of total Parent Rows checked.
I've researched this and cant find a solution. How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to do it only for Parent rows. Also, Can I place this formula on the checkbox column (at the very top for a total) and show a…
-
Link to an uploaded file
Hello, if I have uploaded a file to a row of one of my smartsheets is it possible to link to that file from a site. If so how is this done. Thank you
-
Templatizing
I have an extensive project plan with 250 sub-tasks, which is maintained separately for every client. As 95% of the task list for every client rollout, and the time allocated to every task remains the same; is it possible to automate this process i.e. I simply enter a start date for the project, and each and every task in…
-
Sharing a calendar in an iframe from another system - need HTTPS
I have a sheet that looks great as a calendar. I can use the Publish Options to share an HTML version of the calendar. When I enable this, I get a URL like http://publish.smartsheet.com/xxxxxxx. I would like to include this in an iframe on another site; we use CA Agile Central, previously known as Rally, in which I can…
-
Keystroke(s) to quickly enter toady's date?
Hello, In Excel it's {ctrl}; Is there a way to do it in a date field on a SmartSheet?
-
Column Visibility Restriction or Accessibility
My sheet got 10 columns and is shared to 8 people. 8 of the columns are name of the person I shared the sheet with. Is it possible that person 1 can only view and edit the column assigned to his name? If it is can you teach me how? Thanks!
-
OPPM_One Page Project Manager
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
-
Remove Parent data automation when Child dates are entered
Hi all, When using date columns, Start/End the Parent row auto-updates with the earliest and latest of its Child rows. Is there any way to turn off this function? Thanks, Josh
