-
Report Filter to show just current activities
This may be a dumb question, but I want to create an automated email that sends out a list of all activities that are currently in progress, not just something to flag upcoming due dates. I can't seem to figure out how to filter JUST what is going on presently. Any ideas?
-
Help with a Formula for Status Change
I want to create a formula that changes the status colors to red, yellow or green. Below are the criteria: IF Due Date is < Today and progress bar is not "Full", then "Red". IF Due Date is > Today - 3days, and progress bar is not "Three Quarters", then "Yellow" All other scenarios = "Green" Any help or suggestions would be…
-
Counting Number of columns with a value
I am building a sheet that is a high level resource tracker individuals, by squad. I have a column for each month. I want to be able to add up the number of months that have been worked by each individual and then * that by their monthly rate
-
Move Rows Automation - I can't find the sheet I want to move all of my rows to?!
Hi All, I have a Smartsheet which contains client quotations. I want to build an automation that will move expired quotes out to a 'Cold Leads' Sheet so the main sheet just contains confirmed quotes. I want to target the automation so a checkbox is selected by the user, when that checkbox is checked, it will move the row…
-
VLOOKUP matching text, referencing another sheet
I am trying to match a vendor name between two sheets and if it is found to display a risk rating from the other sheet. I am getting the error message #UNPARSEABLE with the formula below. What am I doing wrong? =VLOOKUP("[Vendor Name]@row",{Vendor Risk Rating Summary Range 1,{Vendor Risk Rating Summary Range 2},false})…
-
formulas in a form
Hello, I've created a form with an email and a user name field. I would like the user name to default to the value entered in the email address field. Is there a way to use logic or formulas in the construction of the form to accomplish this? I realize I could use a formula in the sheet itself but wondered if it could be…
-
IF AND formulas
I can't get the following formula to work, getting the #UNPARSEABLE error: =IF([Regulatory Impact Score]@row >= 3.75, "High"), =IF(AND([Regulatory Impact Score]@row < 3.75, [Regulatory Impact Score]@row > 2), "Moderate"), =IF([Regulatory Impact Score]@row < 2, "Low") If I separate these into three different formulas, they…
-
Countif w/ multi drop down
Hi, I have a list of drop down items: I am trying to total the amount of those selected on another sheet. (How many rows contain those three items bundled together). I am getting an error message when I try: =COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, "FMLA" AND "CFRA" AND "Wave Parental Leave")…
-
Vlookup or IF statement
Hi, I have one sheet where I have an attendance list. I have another sheet where I have opportunity logging. From my opportunity logging sheet, I want to do a vlookup (I think ) of the email address to my attendance sheet email address. If they match, I want it to return "Yes" and if no, "No". Can someone please hep me?…
-
Lock Filter option in Collaboration mode
How do I lock the filter option when there are other collaborators to prevent changing the order of the sheet but still allowing cell comments?