-
Formula Assistance
I’m sure I’m not the first to ask this. I could not find a post addressing my question. I am creating a sheet to track invoices through a department; receive to payment. I created a check box column titled 'January - Invoice Received' when the check box is checked i want the next column over titled 'January - Invoice…
-
Help Needed! - IF rule
Hi,, I am trying to total a column based on whether a value has been entered (but to ignore the actual value), giving a total of the cells with values in. Something along the lines of IF value greater than 0, to count that as 1.. Help would be greatly appreciated if anybody knows the formula?? Kindest Regards, Ben
-
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…
-
basic math in Web Form
I would like to see the ability to add, subtract, multiply and divide in a Web-form. Asking for financial information and need to add 5 or 6 boxes to have a subtotal. (at least one box is the multiple of 2 other boxes), Then deduct optional box for a final total on Web-Form. Now I ask the person filling out the form to do…
-
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…
-
Vacation days formula; how to allow for half-days (or holidays)
Not having a lot of background experience with formulas, I am having difficulty determining whether or not the NETWORKDAYS formula can be "adjusted" to include an allowance for half-days. Using the Vacation template, it calculates the number from start to end days. I have added a check-box column for half-days. If this…
-
Contingency based on BRAG status
I've been using smartsheets for projects plans for some weeks now and can manage all of the usual functions that I'm used to but I've got a new challenge. How do i add variable contigency to the duration of a task based on a BRAG status? Example: In an Agile development environment the first pass estimate is RED and should…
-
DATEONLY Formula Error Message
I cannot get my DATEONLY formula to work. It keeps giving me "missing or invalid parameters" as the result. I am trying to create a formula that gives me a date variance between Planned Start and Actual Start. My two column names are Planned Start and Start and I am trying to start in row 5. This is the formula I have and…
-
use conditionals or formulas to show or hide child rows?
is this possible? Example: Child rows start hidden. If a column in a parent row is checked, the the child row is made visible. More info: I am trying to create a type of set up where I can use a sheet as a form where if the person enters "yes" in a cell, I an guide them to answer the next in a series of questions. This is…
-
Booleans
I need the formula for counting the checkboxes in a column.
