-
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…
-
How to aggregate sheet summary data into another sheet
Hello, I am currently working on developing a workspace to track system testing. The way the workspace is currently set up is having a summary level sheet that has each script, and then a folder per script. Within each script specific folder, there is a script summary sheet and a test script sheet. There can be multiple…
-
Copying a row without sub-rows
I'm trying to easily capture completed project data by copying a single row's data to another sheet so I can run reports off that new sheet's data. HOWEVER, the automation to copy rows copies all the indented rows with it... I'd like to just copy the data from the single row. Is that possible? Does somebody have a…
-
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…
-
Combining multiple NETDAYS but some are blank
Hi. I have a formula that works but only if there are no blank cells. I want it to work while some of the date cells are empty. This formula is intended to keep track of equipment rentals. Sometimes only one person rents equipment and sometimes multiple people rent equipment for short periods of time, but I have to make…
-
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…
