how do I have the start prepping date calculate off the meeting date automatically in the same row. ie I have a meeting on 1/22/18 and I need to start planning 10 weeks prior and would like it to be a…
Hi, I want to create report with contact details based on data from my sheet. The problem I have is that in sheet I have some duplicates. Is there a way to add only one of duplicates to the report?
Hello all, Im using Smartsheet to automatize a lead process with around 30 people involved. We get Leads in an external network, I add them to my Smartsheet Sheet and then the one in a contact column …
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/…
Good day All: How do I get my formula to display in decimal format? My formula currently display 1 but should display 0.5. [C5]14 = 7600 [C6] 14= 3800 Formula: =IF([C5]14 > 0, ([C6]14 / [C6]14)) Thank…
I keep getting # Unparseable error with this if statement: =IF(RC@row= “RFI-1”, "*Request For Information*” ,IF(RC@row = “RFI-2”, “**Request For Information, Second Attempt**” ,IF(RC@row = “RFI-3”, “*…
Hello, I'm trying to have a formula in my parent row status (red, yellow, green) where it will answer with a "summary" of all the children status. For example, if all 5 children rows were red then the…
I'm trying to create a formula in a checkbox column. This column is called complete. I would like the complete column to automatically check once one of two statuses from a status column is selected. …
I'm completely stuck on this one and not even sure it is possible. I am trying to compile data from a sheet to be used in a dashboard to show total time to complete "phases" of a project. I need a for…
