-
Formulas and Newly Added Rows
Hi, Our case application requires a lot of movement of rows between sheets, and I am having an issue with Formulas not automatically applying to newly added rows which necessitates going into the sheets and manually clicking and dragging the formulas to newly added rows from the rows above (time consuming with multiple…
-
Percentage of certain type of hours submitted
Hi, I'm looking to get a percentage of the total number of hours submitted for a certain category from a drop down list within a time frame. In column A is the date of the submission, column B is the category (e.g. Internal Meetings, HR, General Admin etc.) and Column C is the amount of hours submitted. I would like to be…
-
IF Formula Help
Hello, I am trying to write a formula that checks the box when a condition is met. In this case, when the Job Status is marked as As-Built Submitted I want the check box to automatically be marked. Please note the Job Status column is a drop down: Thanks!
-
Need assistance with a formula
Hello, I am using the below formula to count the number of rows where 140R was checked previous month. This formula was working perfectly fine until this month when the year changed. How can I fix this formula where previous month should be looked at December 2019 for January 2020, but it should look at January 2020 in…
-
Nested Ifs checking for different conditions
Hello, I am trying to add an additional argument to a formula to check if a cell called "Awaiting Response" is not blank, and if so, change a RYG cell to yellow instead of red, but I am getting either #UNPARSABLE or #INCORRECT ARGUMENT SET. The conditions are all based on when the last response was to a ticket, with more…
-
At Risk Flag Formula Help
Hello, I currently am using the below formula in the At Risk column which works just fine. If baseline due date is 3 days out and status is not checked off as complete as well as % complete is not 100%, flag as at risk. =IF(AND([Baseline Due Date]@row <= TODAY(3), [Baseline Due Date]@row >= TODAY(), Status@row <> "Yes", [%…
-
How to apply the same 5 different criteria's in conditional formatting for multiple columns quicker
Hi, I have set up a smartsheet to measure the performance of staff. So 0 = not evident 1= somewhat evident 2 = Evident 3= Above Expected Once the performance of a staff is observed, the observer keys in either, 0, 1, 2 or 3 etc under the persons name. There are over 30 different criteria's to look at. So Mary might be a 1…
-
Email from Rule
Hi everyone, I have a rule set up to send me an email whenever a row is added. I'm not sure why, but when the email comes through, the fields are highlighted in yellow. Is there a way that the information comes through without being highlighted? Is the rule correct? Attached are images of the email and the workflow. Thanks…
-
If Status is "Complete" Fill in #of Stores information into "# Stores Complete
Hello, I am looking for help writing a formula for: IF Status = Complete - pull value from # of Stores into #Stores Complete Column. Thanks, Molly Morton
-
Formulas Not Autofilling With Form Submission
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula. According to this help article, it should be autofilling the formula into the new row. What has been driving me crazy was…