-
Double check my formula
This formula turns the Harvey Ball gray even when there is a blank child. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", IF(COUNTIF(CHILDREN(), "Update") >= 1, "Update", IF(COUNTIF(CHILDREN(), "Gray") =…
-
Cell linking within the same sheet
I have a project where I have a start date and due date for each of my tasks, however on a calendar report sometimes I want the start date to show up on the calendar (when it GOES to reviewers) and sometimes I want the due date to show up on the calendar (when the analysis needs to be COMPLETED). I've created a summary…
-
Nest IF limit or error in statement
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If there isn't, then what am I doing wrong here? OR is there a better way to do this? The error I get is #INVALID OPERATION (no…
-
Percentage Complete is 100%, want date to auto fill
So I have a column Percentage Complete that calculates when my other columns are ticked off and complete. When it gets to 100% I want the next column Date Set Up Completed to auto fill with today's date. How do I do that?
-
Auto Assign Tasks
I am trying to create a workflow that will change an "assigned to" cell dependent on a number of cell that will be checked, for example: If the product needs to be delivered to the customer then the "product sent" checkbox is blank triggering a " Assigned to Sales Person" if the checkbox is checked then the "assigned to"…
-
How to Use a widget in Sights to show when an entire sheet has been modified by date?
I would like to know how to use a widget in sights to have a ongoing updated date whenever the entire associated sheet has been modified or changed. I have seen it on the sights help page and I have viewed it by watching the tutorial video but there is nothing referencing how to actually create it. I have attached a…
-
How to use a widget to be able to add a modification date in sights?
I would like to know how and I add a widget to my sight page that will automatically update whenever there are any changes or modification done to the associated sheets it is linked to. I see something similar on one of the examples on the sights help pages and videos but it doesn't exactly go into details on how it was…
-
Sheets with Formulas & Web Forms
Whats the best way to handle a sheet (with formulas) populated by a web form? Right now, each Web Form populates at the end of the sheet, where the formulas stop, how can I eliminate that from happening?
-
Calculate duration excluding Weekends
Afternoon, I have a smartsheet where I have a start/received date and a sold/end date. I calculate the difference to determine the duration however I need to exclude Sat & Sun (Friday if possible) in the formula and thoughts? =NETDAYS([Date Received from xxx]263, [xxx Date Shipped Out]263)
-
Summing Values
Currently I have a Spreadsheet that catalogs potential software enhancements. In order for us to determine prioritization we use a spreadsheet to calculate results based on a rating of 1-5 based on 6 criteria. We also assign each criteria a weight as some of the criteria is more important than others. I'm trying to create…