-
How to replace a blank field with contents from another
Hi Community I need help, I have an onboarding form where there are many addresses to be captured. The registered company address is mandatory The main address is optional on the form as only needs to be filled in if different from the registered address. That is great for the form but on the smartsheet I need both filled…
-
Update status in another smartsheet
I have an asset register, each with a unique asset number that also holds a status (In service, out for repair, decommissioned) I also have an asset damages log where an asset is reported as faulty or damaged and is sent for repair. If unrepairable it will then be decommissioned. My question is....... how to I update my…
-
Duration Column with Formula/Dependencies
Hello, Currently, I use a Text/Number column for task duration. I have a workflow set up to change the duration of each task depending on the urgency (either urgent or non-urgent), which is calculated using several weighted questions in the Sheet Summary that populate either a 0 (non-urgent) or 1 (urgent). This setup…
-
Formula Help
I am looking to set up a formula where a status column gets automatically updated to a certain color based on the relationship of the % complete column and the end date column for each row in the plan. Examples of what I am looking for below. If % Complete = 100%, then Status Column = Green If % Complete < 100% and Target…
-
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
