-
COUNTIFS FORMULA THAT REFERENCES A SEPARATE SHEET THAT ALSO HAS 2 SETS OF CRITERIA
Good morning, I promise I've looked high and low for this answer! LOL I have 2 sheets. We'll call them Central and Complete. They are identical. The 2 columns in particular that I'm working with are #1Signing Method (possible cell contents is either Paper/Esign) #2Month Opened (options are numbers 1 - 12). The goal is to…
-
Actual days passed based on % complete and submitted date
Hello, I am trying to write a formula that gives me the days that have passed between the time the percentage completed has been marked as 100% and the actual end date a task has been marked as complete. The caveat is that l don't know when the percentage complete is going to be marked, and the actual end date is to be…
-
Date Calculation: Subtract Days from Original Date
So, I'm a beginner in Smartsheets. I'm trying to build a sheet that has one "parent" date that the rest of the dates are "born" off of (e.g. T-27 days, T+14 days, etc.). I'd like to avoid using Duration because the start date isn't firm (but the end date is). I've been all over the community help section, but no matter…
-
Building a form
Hi, I'm building a form and would like to have it set up in such a way that when for example I ask a question like "What product are you referring" I will very a dropdown option for people to select. Then depending on what the select they would be different selection options. So for "What product are you referring" The…
-
Need some help from my Smartsheet Community
I have several rows that all have CLINS, I/C/A and BATCH columns. I have created a visual below. Here is my requirement: Identify any CLIN that doesn't have a "C" row associated with it. Bottom line is each CLIN and BATCH number requires a C row to be identified. I need to identify any CLIN that doesn't have a C row on my…
-
How to hide a formula in one sheet ?
Hi everyone , Is there a way to hide a formula in one sheet . I want to share the sheet to some partners but I don't want them to be able to see the formulas . I've locked the coulumns containing the formulas but it's not enough . Is there a solution ? Thanks in advance .
-
I can't able to find the special character using ISBOOLEAN function
I need to find the Special character used in the sentence, so I tried using ISBOOLEAN function but It's not working... =IF(ISBOOLEAN([Value 1]42), "BOOLEAN", "Not BOOLEAN") in "[Value 1]42, there is a special character {}, but still its showing as Not BOOLEAN. So someone can help me. Thanks Jani
-
How to use SUMIFS
Hi, When Currency in USD, Rebate Status is YES, how to compute the total of Sales Rebate? or total the Sales Rebate + Presales + CSP ? Thanks in advance.
-
Formula to calculate time
Earlier I found the following formula in this forum to calculate time, as follows: Let's say it is row 1 and the columns are: StartTime1 EndTime1 =VALUE(LEFT(EndTime1, (FIND(":", EndTime1) - 1))) - VALUE(LEFT(StartTime1, (FIND(":", StartTime1) - 1))) + (VALUE(RIGHT(EndTime1, (FIND(":", EndTime1) - 1))) -…
-
#Blocked when using SUMIFS formula on sheet summary
I am getting a #BLOCKED error message when trying to use a formula. I copied a formula that worked and changed the column name, which then gave me the error message. Not sure what is wrong or how to fix it. =SUMIFS([COBID # of Consultants by Project]:[COBID # of Consultants by Project], Level:Level, =1) - this is the…