-
Conditional Formatting
I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions. As an example: I want to show the date cell to show green if it is a future date with a Green Background UNLESS it is within 90 Days of Today's date. If that is the case, I want to show the…
-
Case sensitive COUNTIF
I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that define unique IDs, and COUNTIF unfortunately, is case insensitive, so it is marking…
-
Using a dropdown to pull duplicates
Hello, I have created a "helper" column to help me find duplicate entries within a row. So all of my columns are going to be drop down entries so as to avoid spelling or typo issues. If a person appears in "Faculty on PTO" I need to be alerted if they are entered in any other cell for that date. I can easily set up…
-
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??