-
Hierarchy issues
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I have been tasked with taking over admin/owner duties now. I understand the basics and…
-
Conditional Sheet Population
Is it possible to use conditional formatting or formulas to suppress unnecessary tasks? And, if so, could Smartsheet adjust dependencies for removed tasks? For instance, we have a sheet to track product implementations; however, some products are not elected by a client and therefore we do not have to track their related…
-
CountIf for check boxes
Good afternoon, Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box? Thanks
-
Formula for Quantifying Importance based on Priority Level and Due Date
Hello, I am looking to create a formula to help prioritizing tasks based on importance and due date. I assigned a value for the priority level as: =SUM(IF(Priority@row = "High", 6, (IF(Priority@row = "Medium", 4, (IF(Priority@row = "Low", 2)))))) + ______ The second part of the equation I need to have based on due date. I…
-
Gantt Chart Parent Row Bars
Has there been an update to allow color edit to the gantt chart parent row bars? Thanks - Julie
-
How do I make a Smartsheet that keeps track of initials
I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many times people completed certain tasks.
-
Automation Suddenly Not Working
I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
-
Is there a way to identify and highlight that a particular contact has overlapping dates?
Staff assignment sheet I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.
-
Remove a dropdown option , if it is already selected
Surprised, this does not exist yet in smartsheet. I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable. I am happy to explore the automation workflow option too, but there is no way to configure…
-
Newbie Question: Want to Count "Product Name" but only if its date is in the future
Hello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting to highlight it if there is more than one time the product is mentioned.…
