-
Formula to insert date
I am trying to insert a formula for my start date column so that when my status column switches from "not started" to "in progress" the date automatically updates to the date when the status changed. Is this possible?
-
How can I use Smartsheet to help us with my Pitch deck?
As a radiopharmaceutical company, we have many Pitch decks in order to get grant money. Over the years, I have multiple pitch decks. Is there a way that Smartsheet could somehow help me organize those pitch decks (presentation is in powerpoint format). I am wanting to somehow organize my slides by content (example all…
-
Count Formula if $$ is between certain $$ Values
Hi.. I need to write the following formula to return specific counts (see below); basically, look in the BANK column and COUNT the number of items that are in the $$ range(s). I am using Sheet Summary to populate those "Counts". =COUNT([Bank]:[Bank], >????) =COUNT([Bank]:[Bank], <>????) Thank you.
-
RYGB Due Date/Completed
Hello all, Looking to create a formula using RYGB based on Due Date/Completed. Red - Past due date and not completed Yellow - Within 2 days of due date and not completed Green - Date Completed ON/OR prior to Due Date Blue - Date Completed Past Due Date
-
Adding to Inventory
I'm sure this is simple, but I've searched for a while and haven't found anything similar! I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another…
-
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!
