-
Helper column to differentiate current week from following week
Hello, I have determined a way to identify the day of the week via a helper column formula with additional helper columns for the current week. What I want is a way to differentiate the current week from the following/next week. This is strictly Monday - Friday Business days. I will post below my current situation. Please…
-
Formula to extract month name is not working
I'm using the following formula to extract the name of the month (e.g., "May" if there is a "5") but keep getting an "Invalid Data" error. =IF(MONTH([SLA Month]@row) = 1, "January", IF(MONTH([SLA Month]@row) = 2, "February", IF(MONTH([SLA Month]@row) = 3, "March", IF(MONTH([SLA Month]@row) = 4, "April", IF(MONTH([SLA…
-
Trouble copying formulas into new sheet
Hello All! I am having difficulty copying formulas from one sheet to the next- I keep getting "UNPARSEABLE". I have tried copying/pasting in multiple ways, no luck. Details: Formulas look like =COUNTIFS(Type:Type, "GC", Team:Team, "TM") , "Type" and "Team" being columns in each separate monthly sheet. If the columns are…
-
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%"