-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
Copy Automation from one Sheet to Another
Is it possible to copy an automation from one sheet to another?
-
All 24 workflows became invalid today
I was the original owner of this sheet with 24 automations which have been working for months. I went on leave of absence for 6 weeks and ownership was transferred to someone else who doesn't know smartsheet. I came back a week ago and everything was still fine. Suddenly today I got 24 emails (and so did the owner) for…
-
Please enhance Column Contacts and Form Contacts by allowing Groups to be used!
I could go on about it, but there are some basic “table-stakes” sorts of features that need to be incorporated into how column contact lists are handled within Smartsheet. First and foremost, please, for the 37th time, allow us to drag a group in and create items contacts within a column contact list. ALSO, please make it…
-
Automation Request: move rows to the bottom of the same sheet
Please allow smartsheets to move a row to the bottom of the page when you click the check mark. Like a todo list. When you click the check mark it moves the row to the bottom of the list and the incomplete items are left at the top of the list.
-
Unable To Create Project Using Control Center
Hello community! This is my first time trying to use Control Center so bear with me. I've been tasked with creating a solution within Control Center to provision new projects. I have my project sheet, I have my intake. I created a program and blueprint on the Control Center side. It references the intake sheet and a…
-
COUNTIFS Formula Based on Status and Due Date
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
-
Names not emails as titles
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
-
Change color of milestones in Gantt
Hello. I would like for the Gantt to reflect my organization's color scheme better so that I don't have to recreate Gantt charts manually in PowerPoint presentations for sr leadership. Currently, I can change the bars in the Gannt, but I cannot change rollup bars or especially milestone diamonds.