-
Row numbers
Hi, I have seen multiple threads around this but still I'm surprised there is no dynamic solution for this, I have tried auto populating ROWID by AutoNumber column and as you can see in screenshot whenever I try to add a new row in between it calculates the row number from the bottom (WOW), this is very bad and this is…
-
Last 7 Days
I need a formula that counts the number of requests that have been submitted within the last seven days if assigned to "John Doe". Smartsheet's AI generated this formula, however it comes back to me as #UNPARSEABLE. =COUNTIFS({Filing Submitted Date}:{Filing Submitted Date}, {Filing Submitted Date}@cell>=TODAY(-7), {LRT…
-
Formula Assistance 🙏
I have the following data set: Wellness Annual Total Wellness Expense Wellness Remaining Education Annual Total Education Expense Education Remaining $1,000 $500 $500 $5,000 $4,500 $500 I am trying to write a formula for the wellness remaining column, but I have a rule I must follow that is giving me a headache for the…
-
Pull most recent entry based on date comparing two sheets
Hello, I am having an issue writing out this fromula and needed some assistance. I need to write a formula that checks for an ID number titled MLL ID [ie. MLL00132] that is an auto number on the sheet I'm writing the formula on. I need it to look at two sheets, an open work and a complete work. Both sheets have a created…
-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
Convert VLOOKUP to INDEX/COLLECT?
Hi, I am trying to calculate the fees for a project based a list of fees from another sheet. My current formula works when only one product is selected but does not work for multiple products. Would converting this to INDEX/COLLECT work? And if so, how would I do it? Current formula looks up the value in Project Type/Scope…
-
Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.…
-
IF formula from Excel to Smartsheet
Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance +…
-
Collect values from another sheet
I have a worksheet with 5 columns that are multi-select dropdowns. The dropdown for each of the 5 columns is exactly the same; 400+ Store #'s. I would like to collect in another sheet ALL of the selections from one column and compare those to the actual list of Store #'s. The object is to identify if a store # has been…
-
At Risk Function using date midpoint?
Hi everyone, I'm hoping someone can help me here - because I'm completely stuck. I'm working on building an equation that flags something as "at risk" if the following conditions are met Project Status is "In Progress" The halfway point between the Project Start Date and the Project End Date has passed. Percent Complete is…