-
Compiling Inventory Data Living Across Multiple Columns
Hi everyone! I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 different columns) to track any products counts taken out. I would like to be able to take those 5 numbers and compile them into…
-
Random Updates - Cell History
Hi, we've been using a format where once a form is submitted, a row is copied to another "master" sheet that the team can manage off of. Recently, I've made some changes to the process (around when the copying happens), but what we're seeing is that in our Master sheet, there are random updates to cells (we have alerts set…
-
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 <…