Discussion List
Dynamic Chart
I'm trying to create a dynamic chart that shows a number count for the past three months. I figured I could set conditional formatting to change the font or row color based on the date but is there a way to pull (only those with the color) into a metric sheet to create a graph? Or any other way going about that?
AVERAGEIFS
Good afternoon community, i am trying to transfer an excel formular into Smartsheet and i am having issues with the formular due to it being an averageisf formular. The formular: =AVERAGEIFS($R:$R,$S:$S,BC5,$D:$D,$BD$3) The logic: The calculation is: if both the indicator and the month (as a number) match, then calculate…
Children Rows of an Auto number.
I have the first column as an Autonumbered for requests. Some of the request will have sub requests and I am wondering if there is a way to create a child row without having a new autonumber generated.
Copy row automation not working
Hi all, I have set up an automation to copy rows that have a specific types: Action, Risk, Issue, Decision. However, the automation also picks up rows with other types (like "Agenda item" as screenshot below) Does anyone have a solution? (Original sheet) (Sheet where the row is copied) (Automation)
How to put birthday celebrant in the dashboard
Populate cell with selection in one of multiple columns
I'm very new to Smartsheet and I don't work with formulas often. I'm hoping there is a fairly simple formula out there to make this work, but I haven't had any luck so far. What I'm trying to do is systematically populate the "Funeral Director" column with one of the selections made in either the "AJ Holly Directors",…
Visual Studio Python Extension Smartsheet API Not Working
My Python environment is handling the Smartsheet API Token just fine. This is great news! But, my Visual Studio with Python extension is erroring out. Any suggestions?
Can 2 workspaces have same name?
Using the PMO template. I create a workspace for each customer onboarding opportunity that is sold. After a year, I am now getting additional opportunities for existing customers. Is it best to create a new customer workspace, if so, does the name have to be unique? Is there a better way? Here's the PMO folder structure:…
Timeline - bar shape formatting
customize the bar shapes, like adjust vertical height global or individual, and adjust space between them vertically
Count multiple names in one cell without knowing new entry
I have multiple names in one cell and no fixed list of names as if whose names will be there in the new entry and want to count unique names. How to do that using countif ?
