-
How do I Automate a Checkmark IF another cell is a certain value
Hi All, I am trying to automate a checkmark in a checkbox column if the function returns ANY of the dropdown values from another column. For instance, If the Project Team (Column) assigned is either "DPMO", "Engineering", or "Clinical Effectiveness", I want the cell to have a checkmark ("1). If it has anything else, Iโฆ
-
How to use @row inside the OR function
When using the OR function inside COUNTIF, can @row be used? The following is a basic example when calculating the number of times an agency names appear. ยท The formula references the Agency column in another sheet which has three possibilities. One option is โBOTHโ which represents both agencies. Therefore, a count of oneโฆ
-
Formula that triggers flag if any cell@row changes color
I have multiple very long complex sheets with a lot of data. With conditional formatting, many cells will change color when there is an issue with a date, number, answer to a form question etc. Having the whole row change color or scanning through all columns/rows looking for issues has proven to be too cumbersome. Whatโฆ
-
Multiple IF ANDS criteria
Hello! I'm trying to write a function for 3 criteria with if ands, "Approved", "Not Approved" and "Pending". Not sure im using if and correctly. It's a document approval process which requires 5 individuals to review a document. I want the status of each document request to be shown per individual and then have the overallโฆ
-
Comparing Several Smart Sheets
I am trying to create a smart sheet for customer collections and compare it to previous weeks of data. So ideally I can export the data which has customer name, different aging columns like 1-30 past due all the way up to 90 days past due and then right after that would be a notes column to put notes about the interactionโฆ
-
Sheet Summary Dailies
I am trying to track daily hours in a sheet summary for a number of employees. They currently populate their hours into the sheet each day. I am trying to create a sheet summary that pulls the current days hours for each employee that I can then create a report and further export into an excel. I am trying to find the bestโฆ
-
Does Data Shuttle's Upload Data work in a sheet that has column formulas?
Hello! I've been having successful experience using Data Shuttle Upload Data with sheets that are referenced in another sheet. Now I have a sheet (sheet name: Tracking) with multiple column formulas, Data Shuttle Upload Data work doesn't seem to work... When I try to set up the workflow, the columns that are formula drivenโฆ
-
Restrict duplicates in a dropdown single select column
Hello all! Does anybody know if SS has a way to restrict duplicates in a dropdown single select column? For example, "Project 4" is already using "D," so when I select a value for "Project 5," "D" would not be available since it's already in use. Or, if I select "D" for "Project 5" it would automatically change "Project 4"โฆ
-
NETWORKDAYS Formula < =NETWORKDAYS(MAX({Range}), TODAY()) >
=NETWORKDAYS(MAX({Range}), TODAY()) With the formula listed above I am attempting to find the difference in workdays between two dates. The MAX function is pulling the latest date from a column in another sheet. The TODAY function is referencing the current date. If the date discovered with the MAX function is todays dateโฆ
-
Help with a formula that I need to return the result of Green for 2 reasons
Good day: I have my formula mostly figured out (see below). I want the result of green if my % Completed is 100 or if the End date is >15 days from today. How can I accomplish this? =IF([% Completed]@row = 1, "Green", IF(ISBLANK([End Date]@row), "Blue", IF([End Date]@row < TODAY(), "Red", IF(([End Date]@row - TODAY()) <=โฆ