-
Adding up "revenue at risk" in a sheet summary based on RYG status
Please can anyone give me a hand on how I can add up "revenue at risk" in a sheet summary based on RYG status? I tried the following: =SUMIFS([Sales Price]:[Sales Price], Status:Status, "Red") The Sales price column is formatted for US Dollars and I would like the "revenue at risk" summary to be in USD as well. The status…
-
PTO ACCURAL TO REFRESH ON JAN 1ST
Has anyone figured out how to refresh the pto accrual on Jan 1st? This is my formula that works fine in this current year: =IF([EMPLOYMENT TYPE]@row = "FULL-TIME", [WEEKS WORKED FROM START MONTH AND DAY TO DATE]@row * 1.66, 0)
-
Help with IF/ Then Formula Based on Number of Rows
Hey Guys, I want to create a formula that will return a statement when a number of certain number of rows is reached. I have a unique cell that has a number let's say 10, and I created a helper column (Row ID) that will simply designate each row by a number. I want to create an automatic statement in another cell that will…
-
What Function To Use With Multiple Values
I am trying to make a sheet that allows me to select an item (product) from a dropdown menu and then auto-populates a unit price for that specific product. I have 16 different products listed and different prices for each product. I have tried the =IF(CONTAINS() function and =IF(OR() function. The =IF(OR() function worked…
-
Julian Date to Short Date
I am trying to write a formula to convert a Julian date to a short date. This formula isn't getting the job done. Any recommendations would greatly be appreciated. *note - this formula does work in excel Julie Date Column: 21123 Short Date Column (text/number type and date type were tried) =IF(0 + (LEFT([Process Julian…
-
Use something other than Char(10) in Join/Collect Formula
Hey Community, I created a Join/Collect formula. Instead of using a line break as the delimitator, I want to use the & symbol, or perhaps a semicolon. Does anyone know what Char # I need or how I figure out what I need? (I have a dell computer with Microsoft Windows.) Thanks
-
Index Match Function Help
Hi Smartsheet Gurus, I am attempt to pull information from one sheet to another given a set criterion that is present in both. I believe that either a VLOOKUP or INDEX function should suffice but cannot seem to get things to work. A little background: We would like to be able to have employees enter a form with data about…
-
How do I reference one cell to the left?
In Excel I use this formula =INDIRECT("RC[-1]",0)+1 to create a row that could look like 23, 24, 25, 26, etc... for example, but this formula does not work in Smartsheet. I cannot use an absolute reference because I need the value for each cell to be one greater than the cell to the left, instead of one greater than the…
-
If cell matches string criteria in one column, THEN return value of another column (same row)
Hello all, I have the following problem. In my first Smartsheet under the column "Revised Catalog Release" I want to output a date value if a criterion is meet. Now this is the other sheet I am referencing: In lay man words what I want is: If column "Task Name" = "Packaged Part Catalog Release" then please return the value…
-
How can I count items only when 3 specific criteria are met?
Hello All, Novice user here - I am building a data sheet for metrics and am hoping someone could please help me figure out the best way to create a COUNTIF/IFS formula that will only count a status 'type' (Complete, Scheduled, etc.) if the Core OpCo is 'FLA' and the year is 2022 and the LFCM OT box is 'checked/True'? I'm…
