-
Formula that will add 1 to a Qty row
Newbie to Smartsheet...I am wanting to write a formula that would at a quantity of 1 if the prior column has a date in the cell. I am trying to calculate the # of installations. basically if a date is entered into an install date column, I need the formula to add a quantity to a install quantity column. thanks, sGF
-
Change column cells based on different column input
Hi, I'm trying to create a formula that will change a cell in a particular column if the value in another column is Yes or No. For example, I have a column of statuses and another column confirming if it's an issue or not. If the issue column says Yes, I want the cell in that row in the status column to say Assigned. Been…
-
Dynamic Default Date
I am trying to set up a default date within a form field to always be today's date + 5 days. For example, I am creating a marketing asset request form. I would like the review date field to default to a 5 day turnaround time, with the option for the requestor to modify the date if needed. Is there a way to do this?
-
Summing totals with 2 variables
I am trying to sum the amount of time it takes a specific individual to complete a certain task. I am trying to determine the best formula to use to accomplish this. I have been using SUMIF but not sure how to get it to work with two variables My worksheet has 3 columns: Name, Task, Minutes I need to identify the person…
-
I can't get a COUNITF formula to work
I'm new to formulas and haven't done a COUNTIFS formula before. I'm trying to count data from two columns of the same sheet where 1) the date is in the past and 2) a checkbox is selected. What am I doing wrong? =COUNTIFS({Daily Screening MAIN - Sheet Range 1}, < TODAY()), ({Request to be Onsite}, =1)
-
Help with Metric sheet
Hello, I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Developing existing formula
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", [Post AFC Change Status]7 = "2. QA Rejected", [Post AFC Change Status]7 = "6. Returned by NR PM", ISBLANK([Post AFC Change…
-
How can I modify this equation?
I am running a report based off a request intake sheet that pulls the 1st choice date and 2nd choice date selected on a form request. This report will be put onto a dashboard and show only available dates (dates that have not been selected as either a first choice or second choice date on a form submission). I have created…
-
Help with month end formula
Hi, I'm building a dashboard to track referral responses. The missing part of my dashboard is I need create a formula that gives the total for each category by month and year. I can't figure out what function I need to add the the formulas I already have to break down the total by month and year. The formulas I've built so…