Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each ite…
I want to look up a value from a dropdown in one column and enter text into another column based on the value found in the first column - is this possible? I can't seem to work it out! For example, if…
I need a way to match a list of volunteers to meetings in their area. Sheet A houses volunteer information, and the input is a Smartsheet form. Very basic, houses employee info and state (has multiple…
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…