-
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!🙏
-
Expected Progress
Hi, which formula can I use to calculate the expected Progress (depending on the current date)? Thanks
-
Is it possible to create a conditional rollup for $'s OR display the max value for %'s?
I am working on a smartsheet tracker that can track the cost savings of specific projects on a month to month basis, then rolls up the total YTD savings. There is also an option for the users to enter their project progress as a percentage, in which case I would want the YTD column to display the maximum % from the year…