-
IF formulas
Hi there I'm pretty new with SmartSheet and am in trouble with a formula... I want to have a formula for the following: I have four competency levels; basic, proficient, advanced and expert. I want to get the unchanged indicator if targeted and actual competencies levels match. If the actual competency level is below the…
-
Auto fill date from forms
I am trying to set up a formula that pulls data from a form / sheet to a master sheet. When a user fills out a form (see pic) I would like the date to auto populate in the corresponding column on a different sheet. Example: The "flight review" box is checked on the form and submitted. On the master sheet, the date the form…
-
OR Function Help Needed
I Created this Formula Below: =COUNTIFS({Discharged Date}, >(DATE(2023, 5, 26)), {Date Activated}, <(DATE(2023, 6, 2)), {Status}, OR(@cell = "ACTIVE", @cell = "DISCHARGED")) However, i need to add in an OR function to the first 2 phrases. it should count if {discharged date} is greater thatn 5.26.23 or Blank, AND {Date…
-
Formula for %
Im looking for a formula to return the percentage that our projects are over/under.
-
SUMIF within the last 30 days?
I am trying to sum the totals from another sheet that fall within the last 30 days. I've tried the "TODAY(-30) function but can't get it to work correctly. I'm assuming I need to add something to this formula that is currently giving me an all time total: =SUMIF({Flight Activity Report Range 1}, MATCH(PILOT@row, {Flight…
-
ROI Calculation Formula
I have a sheet that gathers numbers for various project costs and for various values. There are two columns that sum each of these; Total Costs and Total Value. I am using the following formula to calculate the ROI: =([Total Value]@row - [Total Costs]@row) / [Total Costs]@row * 100 However, the calculation seems to be off.…
-
Adding Overall % and Date Questions
I am using the Project Manager Office Template from Smartsheet. I would like to have the very top row (it is almost like a summary row), calculate the overall % complete of the project and adjust the start and end dates as the schedule changes/ progresses. I tried adding a formula to both sections but it would not actually…
-
Coiuntifs Formula Help Needed
Hi! Can anyone please assist with the correct Formula? i'm trying to count how many rows are on a sheet(Reference Sheet) the criterea for the rows are as follows: =countifs STATUS Column is "Discharged" or "ACTIVE" , Discharged/Nonadmit Column is Greater than 05/19/2023 and Date activated column is less than 05/27/2023 I…
-
#Incorrect Argument Set
Good Morning, I've been trying to figure this formula out but I can't seem to get it. I need to sum any amount in the computed count column, match it with the AP tech for a specific month. I've tried swapping the columns around but nothing seems to work. What am I missing? =SUMIFS({011-AP Archive AP Tech}, [Primary…
-
I need help with a if formula to get the $ amount total if another column = a specific item.
I want to make a formula in the Column "A Total" in the highlighted Cell, that will give me the Sum of $ from Grand Total Column if the A is in the Project column.