Whether it is possible to assign a sign off by responsibility to more than 1 person, and either of persons can provide sign off?
Formulas and Functions9Yashwant Singh
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that…
Formulas and Functions30Laurie Bearden
I'm looking to sum the values in the duration column, if the row is not marked as a bug (this is a checkbox column) and if the district name matches a value (in this case Muskogee).
This is what I've come up with and it's not working:
Formulas and Functions13Jennifer Levey
I need to report on the number of items that appear in the current month to date.
Is there a formula that can be applied without necessitating manual entry of changing the month manually?
Formulas and Functions36TeeM
What is wrong with my Workflow? When the % Complete column changes to 100%, I want the row to move to another selected sheet but it is not happening.
Formulas and Functions21TeeM
I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where …
Formulas and Functions15Caitlin Bowman
My =IF([email protected]
="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example,
In the Parent Column, I want to combin…
Formulas and Functions28Sue Crawford (admin)
I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10
From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps)
I would like a count formula that looks at the Steps in…
Formulas and Functions35Frank Falco
I need to tweak the following formula to use a [Status Date] instead of "Today". We publish status reports each Wednesday as of Friday of the previous week. I have added a Status Date column that I will update each week to refl…
Formulas and Functions30Melissa Kosiewicz
I'm looking for a formula to pull a date that is 90 days earlier than our start date but on the closest Tuesday. Thank you
Formulas and Functions25Vyanessa Stephan
I'm not quite sure how to ask this, but I have cell that has a list of teams you can select from. You can select one team, or have multiple teams selected. If multiple teams are selected then the line item (task) is excluded from the coun…
Formulas and Functions22Adam Boyle
I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field i…
Formulas and Functions16Mahshad Farmanbar
I created a form. new entries are entered at the bottom of the form. I copied all of my formulas to the bottom of the form. When new entries come in from the form, they come in below the last row where formulas are copied. Result...formula…
Formulas and Functions23steve50951
I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION.
Here's my Master Smartsheet.
This is the formula I started using based on responses in the c…
Formulas and Functions25Amy Arnold
I have the following three columns Idx, Stage and Steps.
Steps is a Dropdown Multi-Select column.
I want to use the step value from column in another sheet to find which row that step belongs to so I can return the Idx or Stage values from…
Formulas and Functions120Frank Falco
I have a sheet that our PMs approve invoices and another sheet that copies the rows as soon as they are approved. One column is Date Created (Created Date) and the other is Approved Date (Modified Date). When the row is pulled, it captures…
Formulas and Functions17Shelby Simonsen
I got a question.
Is there any way to force upper case on a text column?
I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font i…
Formulas and Functions30Juan-JLC
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available.
Data coming in: Building | Unit Number | Rent Ready …
Formulas and Functions24Xander Brennan
In Excel I can use the SUMIF formula to calculate data from one spreadsheet and show the sum in another Excel file. Excel Formula =SUMIF('2020 Data'!B:B,A5,' 2020 Data'!F:F) - Column B has Supplier List and Column F has all the amounts …
Formulas and Functions31Deborah Kardash
I'm trying to create a PO #. They want to include the date and a sequential number in the PO #, e.g.
I can use the "Auto-Number" function, BUT... they want the number to reset back to 1 for the next …
Formulas and Functions39MCorbin
Good Afternoon Smartsheet wizards,
While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not.
Thank you in advan…
Formulas and Functions38RPIArchShop
Looking for formula help. I have a master Smartsheet with email addresses and a second Smartsheet with a form that will populate with email addresses entered by the user, so they may not be entered 100% correctly (fuzzy lookup?). I…
Formulas and Functions48Dedrick Tai
HELP!!! I am trying to populate my Status field, using RYG formatting (using the % Complete and Finish Date). The cell displays #UNPARSEABLE. I am not sure what I am doing wrong. I have been reading through the comments in the community an…
Formulas and Functions33Lisa Matthews
I am trying to have a box checked if a text matches in a certain column.
To do that here is the formula I am using in the "Key Claim?" column which is a checkbox column: =IF([Type of Claim]@row = OR([Key Claim Dealer Codes]1:[Key…
Formulas and Functions29Billy-Rock
Hi. I am trying to create a formula which uses another formula but keep getting an error message. It works if I use the add (+) symbol but returns an error message when I try to times (*) the cells, i.e. the cost total needs to show the ho…
Formulas and Functions21Mel Plummer
We use SmartSheets to manage our display campaigns. With each of our campaigns, we can have 1 to N different pieces of creative associated with them. I'm looking for a way to group (either by ID, Campaign, etc.) my sheet to show the campa…
Formulas and Functions16Mike Rini
I am trying to create a RYG formula
Have a drop down column with the choices:
I want to say that IF([Staffing Level Impact to MEF]@row = "75% staffing", "Green"…
Formulas and Functions15tcanelli41471
I really like the GPS location that seems to be enabled in the Asset Location template for example. I have about 1000 locations for street furniture we want to upgrade. So we already have the locations in an Excel sheet. How could we trans…
Formulas and Functions20Etienne Portelance
I am trying to create a COUNTIFs for a metric that I need for COVID-19 tracking.
I have a datasheet: LOB, and Record Type
LOB is a drop down
Record type is a drop down either travel or isolation
I want to be able to pair up LOB and the # …
Formulas and Functions27MJLaughlin
I am trying to get a formula for a check box that combines an if AND with an If OR. I have a column labeled Rental Billed that is a check box. There is another column that has multiple status options from a drop down. I want the formula…
Formulas and Functions23Jturton