-
Formula to add 30 days to "Date notified" AND countdown the days until that Date notified + 30 days
I was able to set a formula to add 30 days to Date notified: =[Date notified]@row + 30 Then set another formula to count down the days from the Date notified + 30 days: =IF([Date notified + 30 days]@row < TODAY(), "", NETDAYS(TODAY(), [Date notified + 30 days]@row)) The 2nd formula I have also results in a blank result…
-
Is there a 'Remove Duplicates' feature?
I am attempting to remove duplicate rows in a sheet but can't find an easy way to do it. I used the AI function to generate a formula for it and I got the above result. Just wondering if there is a feature to remove duplicates or if there may be in the future?
-
Formula Error when converting to Column Formula
Any suggestions on what the problem is on the below. The formula works in a signal cell but when trying to convert to a column formula I get a syntax error. =SUMIFS([# Of Guests Attending]:[# Of Guests Attending], [VALID DATE & TIME]:[VALID DATE & TIME], @cell = [VALID DATE & TIME]6, [Auto-Number]:[Auto-Number], @cell <=…
-
if and date function
Hello, if a cell has the year 2024, perform this operation (98.17 *3), and if a cell has the year 2023 perform this operation (95.17*3). this is the formula i'm using its showing error - =IF(RTS@row, (YEAR(@cell) = 2024), (98.17 * 3), if(RTS@row, (YEAR(@cell) = 2023), (95.17 * 3))) RTS@row is a date column
-
How to compute aging if date format is in text/number column?
Hi All, Would like to ask what formula I can use in row 4 to compute the aging (in days) between Actual Completion Date and Due Date. All dates format are in text/number. I tried with below formula in actual excel and it's working, however I'm getting 'Invalid value' in Smartsheet. Formula used in row 4: =DATE(VALUE(2000 +…
-
Help with formula syntax errors when converting to column formula
Help, please. I'm struggling to debug this formula in Smartsheets. The formula actually works, and can be copy/ pasted with success. However, I'm getting this error message "The column formula syntax isn't quite right" when trying to convert the cell to column formula. Please help. I can't figure this out on my own. Thanks…
-
Filter distinct values only into new column
Hello! I have a column that consists of rows with values, some that differ and some that repeat [(Cells Linked from TE Tracker)], I want the next column over "Distinct" to only give me the unique values of [(Cells Linked from TE Tracker)] From what I've seen, there is no direct function that can do this, but has anyone…
-
Counting Check Boxes
I am trying to count the number of records that meet specific criteria and have a checkbox checked. =COUNTIFS({Evaluation}, "1", {Resources}, CONTAINS("Scenario 2", @cell)) {Evaluation} is a column type of check box {Resources} is a column type of dropdown When I separate the two ranges and criteria into separate…
-
I have a formula related question - can someone help
I need to calculate for each of the headers how many hrs of each hours type each company has used, but with all the formulas I have tried I cannot get this to clculate correctly, I have manually entered what I am trying to achieve in the example rows, can someone help please.
-
Sheet with Mapped Column No Longer Working
I'm having issues with a sheet that has a column mapping users for a filtered report. The sheet has two columns - PDS Selected that captures sign-ins where session hosts are selected, and PDS for View, a column that maps to PDS Selected and is formatted as a Contact List. This then filters to a report set to Current User.…