-
Looking for a formula that considers two columns
A would like a Check Box Cell to be flagged if the following conditions are met: Column "EDI Error Type" = X AND Column "Error Details" has a duplicate value. *The columns considered are both TEXT and column to be updated is a Checkbox type. I am currently using this formula to flag a box that considers a single column and…
-
Assistance pulling information from one sheet to another automatically
Hello, SmartSheet Community! I could use your help. I have created an example of my problem below. The actual sheets have many more columns. Sheet A needs information sorted by Person Name; Sheet B has information sorted by Pet Type. Sheet A - This is where I would like information to be filled in automatically based on…
-
How can I avoid getting this msg (#Invalid operation) when one of the dates is empty
Hello How can I avoid getting this msg (#Invalid operation) when one of the dates is empty My formula is: =[Site survey request date]@row - [Site survey Actual date it was completed]@row Any help is appreciated… Thank you
-
Every time I add a row to the top of this sheet, the formula changes even though I'm using '$'
I use Smartsheet often, but I'm beginning to use the formulas more and more. I can't resolve this problem. Every week, a new row is added to the top of the sheet. The "Should Have" row, needs to calculate the "MAX" value of the top 4 rows (and since a row is added each week, the top 4 rows change continuously). Whenever I…
-
TotalFloat for Non-Critical Path(s)
Hello, I reproduced a TotalFloat error from a larger project using a simpler template sheet. It occurs whenever there are multiple predecessors for a task in a downstream path. I took some screenshots to show what I am describing. Is this user error or some background calculation with the formula? Formula (Column: Total…
-
Docusign clearing formulas once complete
This became a problem in the recent year but I have a Docusign fill out mapped to one of my SmartSheets and maps in the cells to the areas I fill out on a line basis. I will go through my usual process and send the Docusign however, once the Docusign is signed by the recipient and then completed by me, the entire row will…
-
What is a formula to capture % Complete when the "Status" changes?
Example: When I change the Status column dropdown option to "Complete" how do I write a formula to automatically change the percent complete? I.E. Status is "Not Started" = Percent Complete is "0%" Status is "In Progress = Percent Complete is "50%" Status is Complete = Percent Complete is "100%"
-
Can you restrict columns to write only time/contact?
I know that we are able to restrict columns to write contacts only. However, for some reason even if I have the contacts listed, they still write down their email instead of selecting the contact drop down lists. Why is it not restricting properly? How would you restrict a certain column for the person to input time only…
-
COUNTIFS formula giving incorrect value
My Countifs formula is giving a different value than when I filter on my sheet which is the correct answer. I am trying to pull the number of team members who were hired before Jan 31st, Termed between Jan 1 and Jan 31, are current employees (no term date), who do not fall into the position code or term code in the…
-
Why can't I compute a simple division formula?
I am trying to divide one cell by another cell using the below to formulas. I am getting a #invalid operation. =COUNTIF(Complete1:Complete12, 1) + "" =(Complete14 / 12)