-
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…
-
Need Formula: "Is this person listed again in the next week?"
I'm trying to figure out how to build a formula with this logic. When a person is listed on a row with start and end dates, are they listed again for an upcoming event in the next week? Is it possible to create a formula that gives a yes/no answer. Or gives a count of how many times a person is listed in the next week? Or…
-
Synchronizing data from Microsoft excel into an existing worksheet in smartsheet
Hi everyone, i recently uploaded a file from excel and linked it to an existing worksheet in smart sheet. The file in excel is updated every week. Is there a way i can synchronize the file with smart sheet without having to upload the file again every week.
-
Pulling email from other sheet when corresponding business name is entered
I have a sheet with the name of a business and the corresponding contact emails for each business. In another sheet, I would like for the name of the contact to populate when the corresponding business is entered on the same row. here's what I've tried... =IF([Name of Business]@row = {Recall Business Contacts final Range…