-
Can you use sum and min together
Hello, Im trying to get a min of 4 if PA points and SS points are both active then have 4 or the number that is either ss or pa add to the other columns, is that possible? Here's the formula I came up with but its not working. =IFERROR(IF(OR([Status Detail]@row = "Ready to return", [Status Detail]@row = "Transfer"), "N/A",…
-
Help with COUNTIFS Formula for Multi-Select Dropdowns in Cross-Sheet Reference
Hello Smartsheet Community, I am currently working on a formula that needs to reside in a metadata sheet and am facing a challenge with multi-select dropdown columns. Specifically, I need to count rows from another sheet based on the following criteria: RAID Type is "Risk" Impact Type contains the substring "Business"…
-
How can I get a new row to populate with the format and formulas of the row above it?
The rows will be children of a same group. I am trying to make a simple checkbook style sheet and I want users to be able to add rows and have the all the formulas and formatting iterate down. From the above screenshot, I want the yellow fields to be added and the formula that subtracts the amount paid (yellow cells) from…
-
Trying to copy rows & then mark them 'done'
I'm trying to do something that seems simple but is really frustrating me. I want to copy certain rows to another sheet and mark them 'done' afterward. I've got an automation that copies rows over to another sheet, then records a date & locks the row. I also want to have it change a value in another cell (mark it…
-
Accumulated balance
I need a column formula for Smartsheet considering the following: The first row must fulfill this formula: =BUDGET@row - [AUTHORIZED AMOUNT]@row From the second row onwards, it should be like this: =BALANCE1 - [AUTHORIZED AMOUNT]@row How can I do it?
-
Distinct Count IF or Running Count Total
Good Morning All, I need a formula to count the running total of the Dealer Names as they appear. The current formula I have in Column 14: =COUNTIFS(Dealer:Dealer, Dealer@row) is showing the total times Dealer Name is referenced. In my situation I would need "TriGreen Equipment - Ag & Turf" is referenced twice but has two…
-
Max & Vlookup , Match, Index or other Formula?
Hi all, Formula assistance required. I have a transaction log and I want to evaluate the transaction log to find the latest date(Max formula assumed) and match a cell (Match/ Vlookup / Index / Unsure) in my Summary sheet to pull through the latest transaction information on my transaction log. Example: Transaction log…
-
what is the formula to collect Sprint no, based on the start date for a task from another sheet
I'm trying to use =INDEX(COLLECT({Project PI & Sprint-Primary Column}, {Project PI & Sprint-Start Date}, <=[Start Date]@row), {Project PI & Sprint-End Date}, >=[End Date]@row, 1) but its not working I want to add a formula in this sheet to provide Sprint # based on the start and end date for the task, refrencing to another…
-
How do I set up an inventory management system in Smartsheet?
Hello, I'm looking for help setting up an inventory management system in Smartsheet. We have a set number of chairs, tables, linens, projectors, etc. that various departments at my organization use each day. I'm looking to create a system where they can input their daily needs, and it will show how many of each item is…
-
Need a formula where the children rows = the parent rows
I need a formula that makes all the rows under PPA say "PPA" in the same column. I need the parent row name to basically fill in all the children row names all within the same column.
