-
Uncheck box when the value in the dropdown changes
Hello community As the title states, I'm trying to have boxes uncheck when the value in the dropdown changes. I have attached an image. When "Stage" column changes clear "Fit Plan Attached", "Approval Sent", & "Approval" column check boxes.
-
Trigger Checkbox check once week meets criteria
Hi Smarties, I have a Checkbox column that will be checked automatically when an End Date is met. This checkbox is then used in a report and published that particular row in a dashboard. =IFERROR(IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()) - 1, 1), "") However, I totally overlooked that this will also trigger…
-
Formula Question
Hi Everyone! I am trying to create a formula for the following. I have been trying IF, IF/AND, and IF/OR, but I just can't seem to get it right. I have 5 approval columns in a spreadsheet. Each column has a drop down and the person approving will select approve or reject. I then have a 6th column that will be the final…
-
Formula to always Summarize all 5 cells to the right of a column, including new columns added.
Hi, Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on? I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right. Thank you,
-
How to remove decimals from a percentage formula with text before it?
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 someone advise how I can fix this? Fairly new to Smartsheets so I'm still learning! I've tried to click the 3 dots and remove…
-
IF statement for personal template
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 show a different number based on the selection in the Group column. If the group column is Apple, I want Quantity Budgeted to…
-
If() and date functions
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 column. The year column uses two different forumlas, which are shown in "column 4." I would expect that the second line…
-
Can you generate a date with limits?
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 from the review date. However, the program ends 12/31 so I want to add a limit so that if 60 days from the review date is after…
-
Why doesn't INDEX(MATCH) work as intended?
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. Each sheet needs to refer to the same core set of unique IDs entered in the primary column for Sheet 1. All sheets contain…
-
IF Formula - Not Working
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 798.56 as OVER 5600 and returninng 5600. =IF([2023 Beginning Balance - Char]12 >= "5,600.00", "$5,600.00", IF([2023 Beginning…
