-
If / then statements with subtraction problem
Hello everyone, I was hoping some of the pro's on here could help me figure something out. I'm creating a hours tracker for employees to use remotely and I need to calculate the overtime hours as anything over 8 or anything over 10 depending on the answer given in a column. So if [certified] = "Yes" then subtract 8 from…
-
Formula to automate a dashboard and reference previous / next cell
Hi, I am trying to build a formula to remove a manual step in a report. I'd need some guidance on how to do. In the screenshot below, I want to automate the % of change calculation. % of change = last week SLO - this week SLO. I think I can use the "Used in Dashboard?" column to build a formula but not really sure how to…
-
Two columns are checked then want separate column to show green
If one column is checked and one is not want to show yellow if both columns are unchecked want to show red.
-
SUMIF failure
I'm trying to improve a labor intensive process (40+ spreadsheets that do not interact) to calculate a a weekly production metric by Examiner. Basic workflow is that Examiners enter time worked in various categories daily, then once a week production numbers are added and the metric will be calculated. I created the sheet…
-
Is it possible? Have an IF formula to check certain boxes.
I have two columns Target Age and Target Grade. Can you have a formula that will look at the Target Age column and select the corresponding Target Grade. Both of them are multiple select drop down columns. If 5-7 is selected, then check the box K-2nd grade, 8-10 is selected, then check the box 3rd-5th grade, 11-13 is…
-
Formula is not Generating the correct value
So we have a formula in column labeled "Section 1 ended" - =IF([Column A]@row > 20000000, "10", IF([Column A]@row < 1000000, "2.5", IF([Column A)]@row > 10000000 < 20000000, "7.5"))) and it generates correctly. However, when I try to then use the value from that formula in Column B to multiply by 8 in another formula, it…
-
Formula to copy the information of one cell into a different cell
Is it possible to use a formula to copy the information of one cell ( In this case the cell is under a date type column) to another cell (also a date type column) . For example, if my cell #1 under column "concept start date" is: 06/19/19 then automatically my cell #1 under column "Start" would automatically fill up as…
-
SUMIFS - #Invalid Operation - Why?
Hello community, there is a formula problem which troubles me slightly. These formulas work perfectly fine =COUNTIFS({6M_category}, HAS(@cell, [Primary Column]@row), {Time of occurence}, >=[Start Date]#, {Time of occurence}, <[End date]#) & =SUMIF({Impact_to_production_hrs}, >0) BUT this one, does not and returns "#invalid…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…
-
IF Y is blank, and X is not, take Date of X and add 90
i know this is not correct.. but. can someone help me fill in the missing pieces. =IF(ISBLANK([Renewal End Date]@row, [Agreement End Date]7, +90)) my goal is to have the Next Review column produce a date that is 90 days from either the renewal end date (if there is one) or the agreement end date Thank you in advance!🙏