-
Is it possible for summary bars on Gantt to be subject to conditional formatting?
Okay - My conditional formating on this sheet is set to change the color accross the entire row and bar. If status is checked, the gantt bar goes to grey, if not checked, it stays green. The summary bars are not changing. Is this possible? Thanks Jef
-
Automatic Countdown
I am working on a restaurant buildout project list, and want to have a column for "Weeks till Opening Day" and another for "Days till Opening Day". Is there a way to have that automatically countdown to a targeted date?
-
SUMIF Returning $0
I have a "Status" column with dropdown options of "Pending" and "Accepted". I have a second column (CAR Amount) with a dollar amount in each cell. I want to sum the amount of all rows marked "Pending" and then do the same thing with all rows marked "Accepted". I have tried: =SUMIF([Status]1:[Status]64, "Pending", [CAR…
-
Need a How-To: IF [blank addends], blank, IF [values], sum
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Smartsheet Merge & Google Sheets
Does Smartsheet Merge App work with Google Sheets? I have been using the Smartsheet Merge App with the Google Docs, however, when trying to use it with a Google Sheet, it doesn't appear on the list. It seems a shame not to be able to when Google Docs does..
-
New data from Web Forms lands outside analysis range
We have a number of Smartsheets that gather data using web forms. Once the data has been gathered we analyse the responses received via the smartforms using formulea at the botton of the sheet (COUNTIF) This works really well and once we have this data in we can use the charts available in Smartsheet labs to present the…
-
adding service records to a row
I have a plant & vehicle register that I want to add service records to. So each row is a vehicle and I want to keep each service record as a history of the vehicle then I need to export the record for my clients is there a way to do this without adding extra columns?
-
Milestones Report on a Sight
I've got a Report that I'm pulling into a Sight. While in the report, I properly see the diamond symbol for my milestones, yet, once I pull the Report into the Sight, it's showing me the bar, not the diamond. See the screenshots - the one showing the diamonds is when I generate the report. The one with the blue bar is the…
-
Export to letter formatted document
Has anyone tried building a sheet that would have a presentation level, letter format when exported? I'm looking to build proposals within Smartsheet, then I could cell link that final/approved fee into my project tracking sheets for cost comparison etc. In Excel you would typically do this via cell merging etc, but that's…