-
How do I Subtract a series of days from date column?
I need to calculate a series of dates for a newsletter production cycle. I want to take the Expected Release Date ie: 25 Aug 2019 and in seven column cells, beginning with ten days from the Expected Release date, then show 8, 7, 5, 4, 3, 2 days calculated dates from the Expected Release date. I can perform this easily in…
-
Smartsheet file shorcuts
Hi there, Does anyone know how to pin shortcuts for specific Smartsheet files to Google Chrome? Essentially, I'm after the quickest way (minimum number of clicks) to open specific Smartsheet files. Thanks, Paul
-
SFDC Connector - Snapshot Then Track
I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My challenge is that I'm developing a project management process that relies on seeing the…
-
Family Counting
Im looking for a formula that will allow me to index down through a number of children and count the number of decendents under that child. Any help?
-
Primary column not returning values in Report
I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report. Interestingly, when I print the report to pdf, I see the project name values.
-
Editing Conditional Formatting Rules
Hi, Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions? Example: If column 1 is 'yes' and column 2 is 'in the past' and column 3 is 'blank' and column 4 is 'not blank', and i wanted to…
-
How do I get around approvers being on vacation in a workflow?
Hi there, We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given project to gain approval.…
-
Tags (possible feature request)
Hi, is there any way to tag rows? I can use a dropdown list, but that only allows for one "tag" per row. I could also use a comma-seperated list, but without autocomplete and/or tag-management it's a very error-prone approach. All feedback is much appreciated!
-
Project Management and Stakeholder Logs
We're using smartsheet to track a land acquisition project for a utility. Each row will contain a contact, parcel features, a dates of progress. We need a way to manage daily communication and updates. We have considered using comments and a remarks column. Is there a better solution? Thanks!
-
PICK CHART and Smartsheet Template
A PICK Chart is a very effective Lean Six Sigma tool used to categorize process improvement ideas https://www.vertex42.com/ExcelTemplates/PICK-chart.html I am still a newbie using Smartsheet -- is there a template or can SS be created to match the example "Action Item List with PICK Ranking" shown in the above URL (near…
