-
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.
-
formula not showing Dollar symbol
I have column (B) join collect Items @row. I have Column (C) join collecting multiple Column (B) items based on unique values. =JOIN([Cost Center]3:[Rec'd Approval From 2]3, "-") I would like to have the dollar symbol in Column (A) to be present in columns (B) & (C) =IF(ISBLANK([unique.invoice]@row), "",…
-
Can you automatically populate the Owners list?
I have two columns: Task Team & Task Owner(s) Is it possible to automatically populate the Task Owner(s) column based on the value entered in the Task Team column? Example: If Task Team = Technical, then Task Owner(s) = Bob If Task Team = Training, then Task Owner(s) = Kathy and John