-
Sum of each Dropdown Option Selected Formula Help
Any Suggestions on the simplest way to formulate this? * Dropdown Column - "Part Status" * Dropdown Options - "Delayed" "Not Started" "In Progress" "Warehouse" "Shipped" I want to show a total sheet sum for EACH Dropdown Option shown. Part Status is only selected on the Parent Rows. Rows 4-287 with 30 Parent Rows. Thanks…
-
Remove print range lines from Gant view
I have a sheet which uses a gant view. After I had exported it, I now see print range lines running vertically on the sheet. Is there any way to remove these? I have found that the export functions don't meet my needs and I would rather take a screen shot of the gant, but the lines don't look good. Thank you very much
-
Reminder Notifications: translate from templates to new sheets?
Loving Smartsheet so far, and excited about finally having a truly custom system together for tracking project status for our clients, based on our unique parameters and not something superimposed! I've created a template that is working well, but would love to see reminder notifications translate from the template to…
-
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?
