-
Formula
So, I'm tracking payments of invoices. I want to use the RGY balls but only the Green and Red balls to be designated in my Paid in Full? column. I am using the Invoice Amount and Payment columns to set up my formula. So far, the first part of my formula works. Whenever the invoice amount equals the payment, the Paid in…
-
Conditional Formatting for Past Due Time
I have a Task Due Date, Due Time, Completed Date, and Completed Time columns. How can I create a conditional format for tasks that are past the due time. Due date is easy, but I'm stumped on the time...
-
Join/Match/Count Criteria
I have a sheet that is populated by another sheet. And in this populated sheet - I'd like to count how many times certain criteria show up (two specific data points). I assume I would need to join the two columns (i.e., Last Name and ID) and then if these two items show up together again, I'd like to have a count of these…
-
Using IF formula to reference any change in cell (adding a value)
Hello Experts! I was wondering if a formula like this is possible: =IF([Confirmation #]@row = "any value", "Confirmed") When a confirmation number is added to a cell, that means the item is confirmed. What can I put in place of "any value'? I am just not sure how to do this in the context of my larger status formula:…
-
Planko Status Column - is this possible?
Sheet 1: Col 1: Numbers in row sequence, i.e. 1111, 1112, 1113, 1114 Col 2: Status: Show / Unavailable Sheet 2: Col 1: Last Name Col 2: Number (index/matched from Sheet 1 based on Status Columns) Col 3: Status: Show Sheet 2 is a manual row entry sheet, and what I’m hoping to achieve is that when the status changes in Col 3…
-
Have list of projects in sheet. Want to create a schedule sheet where each project has a row.
The Schedule sheet has dependencies enabled. If that matters. Can I put a formula in the schedule sheet which will add a corresponding record to the Projects Sheet. So Projects has: Project1 Project2 Project3 So I want Schedule to have: Project1 Project2 Project3 And if I add Project4 added to Projects, I want that record…
-
Does task info about being on critical path exist?
I would like to use something like =IS-ON-CRITICAL-PATH in a formula for the health indicator of a task. Does that function exist? I know Smartsheet can show the CP, but can a task identify itself for being on the CP or not?
-
Formula Question
Hi, I’d like to know if it’s possible to add information from one cell to another using a formula, meaning, I have Column A, and Column B, I’d like that when I enter 1234 in Column A Cell 1, it should also Display 1234 in Column B Cell 1. But without entering any formula in Column B. Is that possible? This way, I can have…
-
COUNTIF formula for a date range
Hi, I am brand new to SmartSheets and trying to pull some high level metrics from a sheet into the Summary section. I have never used complex formulas before in Excel or SmartSheets and am trying to find the most basic answer around how to build a COUNTIF formula to show how monthly numbers for my team. My sheet has 3…
-
Survey Score Formulas
Hi! We are launching a customer satisfaction survey this week. When completed, they will want a dashboard showing results. We have 5 departments with 2 questions each. The scoring is shown in screenshot below. I need to create a formula that will tally results and also give average score. My problem is that it's not just…
