-
Change Pivot Table Column Names
Hello, Q1: My end goal is to be able to index collect via pivot tables, is that possible? I noticed that my pivot table automatically "adds" to the column name than initially intended. Is there a way to change that? I just want the column headers to be the first 3 letters of the month, which was I originally have it mapped…
-
If formulas with Parents & Children
Hello All, I have been looking for some help with a formula between parents and children. The goal is to have a column to pull a report off of so when it pulls we know it was a child and not just a regular line. The formula works for a Child but when we want the Parent line in the column to pull the parent data it shows up…
-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Parse Out Number Values in Successor Column
I have found multiple threads on this but I can't seem to get any specific formula to work for me. I have a column to Join Successors =JOIN(SUCCESSORS(Name@row), ",") The highest number of Successors I have is 4 and I'm trying to parse them out into separate columns. I have formulas that work for three but can't figure one…
-
Formula that calculates the multiple choices chosen from a drop-down list
I need a formula that calculates the choices from a multiple selections row. I am currently using the formula =COUNTIF({Link Access}, "Overdue Report")
-
Budget Tracking
Hi, I'm trying to put together a budget for change orders and I want to have the value of the "total" cell of the change order show in a "remaining" cell if "NO" is selected from a drop down. I have been messing with the automation for an hour and I just can't figure out what the formula needs to say to show the value.…
-
Workflow failed due to linked cells. Need help writing formula for Status changes.
I have the following Smartsheet and am trying to automate Status changes based on start and end dates, but from what I've read, I can't do that since my Start Date values are linked cells. Can someone help me write a formula for the Status column to populate either: Not Started, In Progress, Complete, Overdue based on the…
-
Please fix my syntax
Ok, I know it's something small but I can't see it. Can someone please tell me what is wrong with my formula? I'm getting an Incorrect Argument Set =COUNTIFS(Urgency:Urgency, "1 - URGENT Need attention today", Status:Status, "Pending (awaiting response)", "Working on it") tagging my formula guru @Paul Newcome
-
How to Add period only if there isn't one already?
Hello i am currently trying to use a formula that will take a name from a cell and add a period to it since it it the end of the sentence. This is the formula i use. =[Name]@row + "." The problem is, is that some of the names have periods already at the end because its words like Inc. or LLC. so how would I make it add a…