-
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
-
CountIF, AND, OR, & NOT Statements -- Which Order?
Hi! Was hoping someone might be able to provide some insight here. I am trying to work out a status formula where a percentage is calculated based on row values that have text in them. This would also be dependent on different status within the same row. Here's what I've worked out so far. =COUNTIF([GMB URL]@row:[GMB…
-
Date format with Time
Dear Sir, We are unable to keep the date format along with the Time. Example: 12-Oct-2020 12:13 PM Need your advise. Thanks and best regards.
-
Announcing Several Formula Enhancements Available Now
Hi Community, One of my favorite things about Smartsheet is our powerful formula engine. We’ve been hard at work making several improvements that will not only make building formulas easier and faster, but can help you reclaim time throughout your day to focus on the work that matters most. I’m excited to tell you about…
-
Count the number of projects done for a client without sub projects
I'm trying to count the number of projects completed for a client. I've changed the client name to Apples for confidentiality purposes. I want to count the number of projects done for Apples, without including the indented rows. Screenshot below: I have tried the following formula: =COUNTIF(DESCENDANTS(Client:Client),…
-
Auto Date Calculation/Auto Fill Date
Hello, I would like the "Referral Bonus Payout Date" to return a date that is 90 days out from today once the "Referral Bonus Amount" and "Referred By" fields are filled in. Is it possible? Please advise. Thank you!
-
Automate checking a box if date column is less than 2 weeks?
I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank you!
-
If Formula with Dropdown conditions based on Dates
I'm looking for a formula that could be integrated into a drop down field based on a past date. I'm trying to have the "Status" column automatically flip to Off-Track if the date in the "Finish" column is now in the past and the "Status" column is not already in At Risk or Completed status. I'm able to use =IF(Finish1 <…
-
Nested formulas
Hi, I have 3 formulas and I was wandering if I can combine them into 1: =COUNTIF({Survey Date}, Label@row) =COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8") =Percentage@row / Count@row Thanks much!
-
Countifs... something off
Hi there! I am trying to do a COUNTIFS formula for a sheet where I am nesting three formulas into one for results. There are three different columns(ranges) I am using - doing the formula in sheet summary as well. Each of the three formulas works in themselves, but when I nest them together I receive Unparseable... Any…