-
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
-
What formula would I use to pull text into a new column?
I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too long to do (there are over 100 rows). So I want to use a formula to isolate the training type from the "Business Segment, RCM…
-
Max and index match function
Hi all, i have a sheet where Trailers are logged in multiple time throughout the day and what they had in them such as a PO number or a load number in a separate sheet i want to type in the Trailer number and i want it to pull the recent entry date of the trailer and the Load number / po that came in that trailer. How can…