-
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…
-
Checkbox Formula
Hi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes that have been checked off versus the total number of check boxes (ex. Scores Received: 4 out of 20) Can someone provide a…
-
Can a web form user make an update without sheet access?
We have the following request. A department has a sheet to track requests from different people/departments. The sheet has request need, type of request, requester name, due date, and many other fields. Submitters use a web form to submit the request. After submitted, they may need to change or update information. So they…
