-
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…
-
New to Formulas
Please give me formula for: When checkbox column (complete) is checked that the column (date completed) automatically changes to today date.
-
Sight Report Links
I have a sight (dashbard) the provides a summary view and at the bottom a report that attempts to link to another signt from which a more detailed information can be shown. There is currently a limitattion whereby the link to other sheets that a pulled into a Report on sight are not clickable. The strange thing is that if…
-
font color in dropdown lists
Is there a way to change the font color of items in a dropdown list in a web form? Example: My guy is filling out his web form and under the field for "Fire extinguisher is on site" he has an option to put either yes or no, can i make "no" red so that when he submits his form it will stand out in the spreadsheet?
-
Formula Help
Community - Please help reduce this formula. My IT guy did it in 5 mins, and he said its crap, but it works. However, I now have to put it on ALL my projects and its too cumbersome. I didn't even try to do the formula.....I am too busy Here you go...and Happy Friday!! Louise=Amount6 - (IF(ISBLANK([Date Payment…
-
Available Staff for Project
Hello, I wanted to see if anyone had a suggestion how to handle determining what staff is available for a new project when it comes in. -We have a set list of staff that is available to work on a project * -Staff would not ever work on two projects at the same time * -We have a column that has a start date/end date for all…
-
CountIF and Sights Auto-update question
Started using Sights this week, definitely a very cool feature! I've seen some things in the example gallery that I'd like to know how to do. 1. From the Sales Pipeline example in the Sights Gallery, I’d like to have Totals by Month for: Status (Green, Yellow, Red RYG balls) Stage, Rep and Segment (all drop down columns on…
-
combining formula to round a sum
I'd like to know if I can combine the two following formulas in some way so that I only need one column: In the first below, I'm calculating the average number of minutes an editor spends on each page of a document. But, because I don't want to report the number with such precision, I have a second column with a formula to…
-
How can I set a default format for my sheets?
How can I set a default text height and style for my sheets?
-
Formula Help
Hello, Can someone please help me with this formula. I don't know what I'm doing wrong. I have 3 auto fail items and it seems that only the PCI one works. If either Solved, Protected, or PCI are scored No, the end score needs to be 0%. Everything is either scored, Yes, No, or Not Applicable. I have 8 columns: A, B, C, D,…