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 ha…
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 a…
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 calcu…
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…
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 proces…
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%" St…
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…
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 betwee…
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)
Hello! I have two sheets, one that has General Ledger amounts for month end and the other sheet is a summary sheet that pulls in the total of the general ledger amounts for each specific GL. My formul…
