-
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…
-
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…