Hi Team, I have move record functionality in my tables, and for some reason, the incoming records coming into my tables will not inherit the formulas on the columns... even when I have two template re…
So, I'm a beginner in Smartsheets. I'm trying to build a sheet that has one "parent" date that the rest of the dates are "born" off of (e.g. T-27 days, T+14 days, etc.). I'd like to avoid using Durati…
When working within a Dashboard, if I drag a card from one lane to another (Uncategorized to In Progress for example) does that information populate and work on the underlying sheet? Right now on the …
I'm trying to create a formula that will calculate when there are more than 1 item checked in a column to display accurately in my dashboard count. Example: My Strategic Initiative column has the abil…
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Conta…
I am try to count the number of people who are internal coming to an event, so we have a form that people put in what their organization is. If it is internal, it should have Geisinger in the name, bu…
Hey all! I am wanting to create an availability calendar for our call center. We can only accept about 200 calls/week. The goal is to auto-sum the daily volume column for a week period and to set a co…
Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've …
hi, i have sheet with ~300 parent row and ~1200 children row. i try to sum the progress in parent row with IF on his children. for example : if one of the children row is "sent to fabrication" he get …
I have a column called Closure Rate - which is a % formatted field. I want the insert a column to the right that indicates if the value in Closure Rate = <25% then show up arrow, if not show down arro…
