Hi, I currently have the below formula: ="Completion: " + [Product Data]@row / [Units Sold]@row * 100 + "%" The cell then shows "Completed: 4.05405%". However, I'd rather this be "4.05%". Please can s…
I am looking for some advice on how to use a IF statement on a template that my team will use, but it needs to be set up part-way in the template. For example, I want the column Quantity Budgeted to s…
Hi - I've noticed what appears to be a problem with if() and date functions. One issue is seen here: The "date" column is a "date column" and will only accept dates. The "year" column is a text/number…
I am working within a tracker, and I have the date autogenerating. Currently the date will generate once the first update will occur, and I just did =[Review Date]@row + 60 so that it adds 60 days fro…
Hi, all: I've recently been assigned to work on a set of tools for my team that have been run in Smartsheet for some time, and am really struggling. Setup: 4 sheets, for 4 separate project-cycle teams…
Why isn't this working? The yellow fields should be returning the numbers in the column "2023 Beginning Balance- Char" because they are UNDER 5600 (per my formula). But they are reading the 700 and 79…
I need to combine two formulas in one cell. One formula removes a specific text from the body of the email and another formula maps it from another sheet via a VLOOKUP. How would I combine these two f…
Hello, I need to reference information from the Digital column and Match it into the Digital Row. The row in white is the Parent column and the rows in grey are the Children. Here is the formula I'm u…
I'm trying to work out a formula that says if the date in the [Date Column] is the current month insert the word current, but if it's in the previous month insert previous, if it isn't either of those…
All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2 Screenshot 1 =INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk M…
