-
Converting AverageA from Excel to Avg in SmartSheet
I'm having a bit of an issue. I formula in excel that works great. However, when I pulled the project into SmartSheet, I lost all of my formulas. Most I have been able to work around and fix to accommodate SS, but I can't seem to get the one for AverageA to convert. Original Formula from Excel: =AVERAGEA(X3,O3,J3,F3,J3,F3)…
-
Selecting populated column data.
I am trying to use a logic in a form but on the sheet I want the data collected to be in one column.I have 4 columns with dropdowns and a "master column" that I want to populate from the 4 "subsidiary columns" I was able to =IF(ISBLANK([Utility compressor]19), for one column but tried unsuccessfully to nest again for the…
-
Multiple IF/AND Formulas - Need Nesting Help
I am in need of some assistance with a formula. Here is a snap shot of the sheet I am working with: I am trying to create a formula for the Activity Health Status field that drives the RYG ball. I want it to do the following: Blue Tasks that show status of “Complete” Red Tasks that show status of “In Progress” and finish…
-
Can I create a SUMIF "does not contain" with multiple values?
Trying to add up the number of people from all cities but, CityA, CityD, CityF, etc in the same argument. Is there a simple SUMIF formula i could use? Currently I have been using: =SUMIF([City]1:[City]51, <>"NYC", [# People]1:[# People]51) but i want Smartsheet to exclude multiple cities. I've tried a few options but felt…
-
Nested If Formula (Multiple Conditions)
Hello, Hoping to get some help for a rather complex nested if formula I'd like to build based on responses to a webform. Below are the conditions. Is this possible to create an if formula around these conditions to result in a a red/yellow/green visual symbol? Any help or guidance is much appreciated! Thanks so much!
-
Formula that checks if a certain date is in a date range and TRUE/FALSE VALUES
Hello! I need help on a formula that outputs a count and a sum since we are unable to build formulas from a gantt chart. This is the formula page I am using in order to build a gantt chart with a bar chart in a dashboard with month counts and sums. I created this report to show what is needed in the formula. Count: Count…
-
Max(Collect formula
I am trying to put a formula together My result is to identify the most current date based upon each unique Invoice number What am I doing wrong I am getting an incorrect argument Thank you
-
Help with calculating health (R/Y/G/B) based on end date and % complete
Hi, I'm trying to create a formula to auto calculate the health of a task and return the correct R/Y/G/B ball based on the % complete measured against the planned duration and start/finish dates. I created a couple of helper columns (one calculating 50% & one calculating 75% of the duration as a number) to attempt to get…
-
Different formula for a cell basing on condition
Hi All, How can i apply different formula basing on cell value? For instance i have a columns Type, Duration, Original If type = "Sub-Task" I need formula for Original "= Duration*1440" If type = "Story " I need formula for Original "=SUM(CHILDREN())" i tried IF(Type = "Sub-Task" , "=Duration*1440", "=SUM(CHILDREN())") but…
-
Formulas - IF This then do this calculation
Hoping someone can help! I want to do a formula IF Contract ASV is less than 100000, then multiply Contract ASV by .20 and put that amount in the Rev Share 20% of per year ASV in USD field, but IF Contract ASV is greater than 100000, then multiply Contract ASV by .1 and put in the Rev Share 10% of per year ASV in USD…