-
Dashboard widgets - Charts
I just want to tell everyone that with the additions of the chart widget, I am really loving our dashboards. I do wish the legends were editable and the selections didn't have to be side by side. I got around this by creating a second sheet and linking cells to the needed data. I could then create the labels I need and use…
-
Formula creates a String - Cell no longer blank/empty conditional formating
Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8 = 1, "N/A", IF(Coupe8 = 1, "N/A", "")) after this check the cell retains a sting of…
-
Date range formula
Having an issue with date range formula. I am trying to accomplish returning values such as Q2 FY18. Q3 FY18, Q4 FY18 based on the date showing in the "Finish" column. However, I am challenged with the proper format to enter the date range, and then multiple at that. I initially used ... =IF([Finish]2>=10/29/2017,…
-
Pie Charts in Sights
Hi, Thank you so much for adding Charts to Sights! It appears as though the pie charts can only handle three data points, is this correct? Or am I possibly doing something wrong? Thank you!
-
Dependent dropdowns using Smartsheet Sync & Google
Hello, does anyone know is it possible to create a google form and link it to an existing smartsheet rather than create a new smartsheet??
-
Charts & Graphs
Is this in your enhancement plan for Smartsheet? I don't find this feature like how I can create charts and graphs like in MS Excel. Thanks
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Invalid Data Type error
Getting an Invalid Data Type error with this formula: =COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green"))) The second "CountIf" is a symbols column. Looking to make a count of certain 2-letter codes if the status column does not have a "Green" ball. Thanks
-
Nested IF function - Ignore Blank Cells
I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula all the way down the sheet, then the Late Tasks column populates with a 1. How do I write the formula to not include blank…
-
Determining Resource Allocation for Resource View
Hello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project plans for each project, which all feed into the main status sheet. Each project plan is broken down into tasks with…
