-
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…
-
Formula Syntax Help
Hello, I am creating a sheet to track calibrations for the equipment in our department. I saw the function to add months to a date from another cell https://community.smartsheet.com/discussion/smartsheet-formula-syntax-help =IF((MONTH([Purchase Date]1) + 9) > 12, DATE(YEAR([Purchase Date]1) + 1, MONTH([Purchase Date]1) +…
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
New Client Sheet Generator?
Hello, I have a Web Form which Account Managers complete when a new client is to be added to a 3rd party tool. This data transfers to a smartsheet where an email is sent to our 3rd party tool notifying them there is a new client. This data contains the client name, address, phone, email, and POC. At this point, I am…
-
Formulas to calculate data received from web form
This is a screenshot of my page that I want to try and get the formulars for. The cells that are in yellow, the data in those cells will come from my staff that I have complete the web form that i have attached to this sheet. The red cells are the ones that I require the formulas for to calculate the different times that I…
-
If/OR formula
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far: =IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)…
-
Automate Value Recording
All, I am trying to setup a PMO dashboard where I am putting Total Portfolio Value graph. I have to update the graph fortnightly to record current value. Is there anyway to automate this function so that everytime I dont have to manually enter value.
-
IF FORMULA
Hello there! I'm new to Smartsheet and I haven't found an answer to my question yet. I would like to make a symbol appear if a set of cells are not empty. In a few words, if cell A, B, C are not empty then I will have a green ball on cell D. Is it possible? How? Thank you :)
-
Checking checklists
Hi all, I have a series of columns with checklists that I need to analyse and need some help, please. The logic is this: if the report is "completed", but _any_ of the several asset check cells are still not checked, a cell called "asset checks not complete" should fire up. The formula I have is below, but the "asset check…
-
Report on today and next workday
I'd like a Report that shows rows with the Date field from today or the next workday. That is on Monday - shows Monday/Tuesday Tuesday - shows Tuesday/Wednesday ... Friday - shows Friday/Monday Saturday - shows Saturday/Monday Sunday - shows Sunday/Monday My sheet is very complictated and starting to visibly slow down so…
