-
Record a date & Time
Greetings, I have a workflow that requires multiple approvals as well as recording the date each approval status was made. How do I also capture the time of approval as well as the recorded date?
-
Health Status Formula RYGG
Hello, I am new to smartsheets and I am having difficulties setting up basic Health Formula with RYG+Gray bullets based on Status (Cancelled, Delivered) and Due date column. GRAY when Status is Cancelled RED when Status is Delivered, but after Due date GREEN when Status is Delivered till and on Due date YELLOW when none of…
-
Nested AND/OR statement with COUNTIF
Hello, I'm trying to count the number of rows that fit this criteria: This is the formula I came up with but am getting an error. I'm betting that the problem is the placement of the ANDs? =COUNTIF(AND((OR({Retail Survey Launch Status} = "Operational", {Data Upload Status} = "Operational",(AND({Experiencia Rounding…
-
If formula looking at 2 different columns
Hello I am trying to write a formula that looks at two different columns on my Smartsheet and returns a value based on what is in the cells. I want to look at ticket location column and if value is "Complete" I want to return value "Implemented" Second I want to look at Fix Version Column and if it is blank return…
-
SUMIF or SUMIFS (multiple columns and YEAR and MONTH criteria)
Formula Logic (for the formula that would be a column formula for the Jan column - needs to be a single formula): SUM ([Received Count] if [Date Recd]'s YEAR = 2022 AND MONTH = 1) and also SUM ([Completed Count] if [DateCompleted]'s YEAR = 2022 AND MONTH = 1) Thank you!
-
Parent / Child Join(Collect) Statement to summarize Child Rows
Hello! First time poster here! I have found this community so helpful I can usually find enough examples to write the formulas I need but I'm stuck. I have a sheet that is tracking decisions across multiple groups. I am using a parent row with child rows underneath for each separate group. See below. I am going to generate…
-
Help with Lookup Formula using IF CONTAINS Status In Progress/Not Started/Watch
Hello, We run a weekly Sales report of any new Yellow or Red risk customers, that gets added into an Escalation Master Tracker in Smartsheet. Master Tracker may contain matching "Customer Code" entries more than once (past entries marked "Completed" or "Terminated") and new entry status = "Not Started", "In Progress", or…
-
Creating a chart with a multiple dropdown field
Hello, I have tried a few options, but no success. Trying to get a report in a pie or bar chart format that will be reporting off of a field in a sheet with multiple options. The sheet is a list of company projects and the field is a strategic category (Go to Market, Client Service, People & Culture). Some projects are…
-
How to know the order of tasks in card view for use in table view
Hi all, i need to do some calculation in table view depending on the order of the tasks in card view. Which formula or function returns the order number of the task in card view? Thank you, Joachim
-
Formula using AND and OR functions
Hello, I'm trying to build a formula to count the number of deployments in queue by month. All of these criteria must be met: Project Complete is unchecked Project Cancelled is unchecked Row creation month is June Row creation year is 2022 And, deployment type is either New Deployment or Package Upgrade. I started with…