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
I want to create an agenda with start times. I want to specify the start time for the fist item and then have Smartsheet calculate the start times of the remaining items based on how many minutes are assigned to the previous item. Any ide…
Formulas and Functions59Pam Grant
I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formula would look like?
Formulas and Functions22Annie Lindenberg
I am having trouble putting together a formula and I am hoping someone here can guide me in the right direction.
We have a sheet that we enter payments we receive from our customers. That sheet has the customer name, check …
Formulas and Functions165Yehuda
I'm trying to do something that should be so simple.....
I have a several values in a column "A" in a $ format. I want the last row in the column to calculate 5% of the total of above columns. Why does the formula =SUM([Column A]…
Formulas and Functions17Kris Le
I have a column set up in my Project Tracker for my team (of 7 functions), that allows us to select the teams we are cross collaborating with (but those teams don't own the project). As a resource, I want to depi…
Formulas and Functions16Sarah Ko
Hello all! I have a question where I am not understanding the total scope of formulas and functions and would like help to see what could assist me. I am a Customer Success Manager and I create projects for my customers that are onboarding…
Formulas and Functions14Jonathan Forrester
Why am I getting no errors, but a 0 (expressed as a percent as formatted) when using the following formula?
Please note that I am NOT the person who named these columns or the list of values therein, but you've gotta work with what you're …
Formulas and Functions14khankoff
I have contacts that show under 'My Smartsheet Contacts'. I've added them as resources to a sheet, with start/finish dates, and click 'Project Resource View'.
Only a portion of them show as assigned resources. If they're all listed as con…
Formulas and Functions10fred sodergren
I need to write a formula to count the number of projects in a sheet but subtract all projects that are tagged (checkbox column type) if the cyclical column is checked. Does anyone have any suggestions or help they can share?
Formulas and Functions15Deanna Vandermeer
I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names?
Formulas and Functions82Pltrmgrl
i am having difficulties with my formulas .
I am trying to acheive the following:
IF status row is not "complete" AND due date is Today or in the past, if true Flag, if not unflag.
My formula is:
=IF(AND(Status28 <> &…
Formulas and Functions19SharonR
I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria.
Build 30 - …
Formulas and Functions22Travis Duehr
Ive got a drivers record sheet. on the sheet the date is entered and there are columns for the driver name and the asset number. Im trying to return the date for the last time a prestart report was done on a particular asset number.
Formulas and Functions62remkin
I am trying to write a formula that can work out the following
RED - if the start date has past and the complete % is 0
BLUE - if the start date is in the future and the complete % is 0
YELLOW - if complete % is 1-99
GREEN - if comp…
Formulas and Functions20Aimee Colton
I am trying to create a sheet for a moving task that changes each week depending on week number. The idea is to highlight and send out a reminder email to the person that has the task a certain week.
To achieve this I have use the formula …
Formulas and Functions55Leonardo Bello
Currently I'm using this formula to check boxes in a column if the date a proposal is sent is in 2019.
IF(AND([Date Proposal Sent]534 > DATE(2018, 12, 31), [Date Proposal Sent]534 < DATE(2019, 12, 31))
Sometimes there is …
Formulas and Functions20Mahshad Farmanbar
Not sure why my formula (using Index and Match) is returing 0% as a result of matching to another sheet? The correct data in the cell is = 55%. All other columns with same formula working correctly but one dept is showing an error o= 0%. H…
Formulas and Functions23Joyce McMurran
Hi all, I'm hoping you can help me with a thorny problem.
I have a 'Status' column, which is a dropdown which contains 'Not Started'/ 'In Progress'/ 'Completed'. I was also using the '% Completed' column with dependencies to rollup the ch…
Formulas and Functions72LisaB:-)
I have a number of sheets that are fed data via forms. The sheets are setup to deal with this incoming data automatically and they feed selected information to Dashboards via reports and formulas that run within the sheets.
The problem I h…
Formulas and Functions26CRL Planning
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions16Mike Wilday
Hello - I'm trying to do a formula that will count the number of projects that have been completed within the last twelve months. I have one that will count within the last 365 days, but this result doesn't match the completed per month nu…
Formulas and Functions18Donna Claes
I am trying to create a formula to pull information from the attached page (Armorel In-Process Record).
I need the formula to count the number of times each inspector makes a…
Formulas and Functions19Leland Harlan
I am trying to work out a formula that will raise a flag if any contacts in a column (Attendees) are listed on a separate sheet (VIP).
The attendees column could have multiple names listed, the VIP column will only have one name per…
Formulas and Functions15Joseph Noel
I've 2 columns named "Audit Completed by" which contains a result from a contact list and "Audit Result" which gives dropdown result of pass or fail.
Trying to give a sum of when both have a specific username and pa…
Formulas and Functions28Andrew Darley
Is it possible to use a vlookup formula or Datamesh to transfer data when TWO criteria are met.
I have a parent row which is the name of the task and then children row below showing when each employee completed the task (so three columns …
Formulas and Functions20Courtney Holdt
I've setup a formula which tells me if an entry that was submitted was correct / incorrect. I've also triggered an email based on that to send an email requesting an update to the specific field in question. What I can't figure out is if/h…
Formulas and Functions21Mike Rini
Hello SS Community,
I'm trying to count the number of instances two values appear together in a cell. From the following example, I would like to count how often "Contractor" and "Vendor" appear together, and furthermo…
Formulas and Functions57Yogin Bhatti
I have a formula that calculates the week number, and counts all items with the priority of 'Standard' within that week.
The issue is that my 'Creation Date' column currently has 97 rows, but this will increase. The formula below works, b…
Formulas and Functions24fred sodergren
This discussion was created from comments split from: Trying to combine 2 AND functions with an OR.
Formulas and Functions18System