-
Count If Date is Between, Rolling Dates
I have a process that will all automatic rolling of dates. So -2 is two months ago, -1 one, 0 current month etc. So I need a formula that I can use this automatic rolling to check projects on another sheet to count resources during that month that are used by role. My logic: Count if Role matches, Count if "rolling month"…
-
Formula Error
Hello, I was hoping to get some help with a formula. We are using INDEX/MATCH. Its all working great when we are referencing one column. When we change the reference to select a range of columns, the formula doesn't work and we get #UNPERISHABLE. Can someone help us figure out how to reference a range of columns? Here is…
-
If with And Formula help
Hello, I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days. Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micro/QC?]@row = "QC", 1, 0)) I'm getting incorrect argument set error and can't figure out…
-
Formula for status update using number of workdays until finish
I need help with a workday formula. I'm trying to get my status bubbles to update automatically based on the number of days until task completion. I've got it to work counting backward using all days with the formula below, but I can't figure out how to only count workdays. Any help is appreciated. =IF([% Complete]@row =…
-
Workflow trigger for condition not met
I want to setup a workflow to send an email when a comment is added, except if it is added by 'me' [Created by]. I want this to apply regardless of who the user is. Is this possible?
-
Modifying column formula based on criteria of other columns?
Hi all, Is there a way to modify a column formula based on criteria of other columns? For example, if a column is checked, to use a specific date rather than the date listed? My goal is to create a formula that defaults to the 15th of the month IF a certain box is checked YES. Thanks!
-
Streamline my Formula
Hello everyone, Im currently using a very tedious process of finding the number that I need from this sheet. It is a pasted excel sheet into a Smartsheet. There are multiple repeating "CC Codes" that are only differentiated by the "111" number in the Primary Column. I need to find the value for each of these items on…
-
Nested IF OR limits?
I have some very involved nested IF(OR( formulas in my sheet. They all work past the initial IF, and the the first IF(OR( statement, then ignores everything past that one. I'm hoping it's just a syntax issue vs a limitation. Here's one example: =IF([Outsource Due Date]@row = "", IF([Route Number]@row = "FAB-WELD-NOFIN-09",…
-
Excel to Smartsheet formula conversion error
Hello All, I am trying to import Scaled Agile Team Event calendar excel onto Smartsheet. I am facing difficulty in automating Column F - Team Events on Smartsheet. If someone can help me debug the query to work in Smartsheet. I am attaching the excel from Scaled Agile and also pasting the query down here. Excel Column Team…
-
Multiple conditions IFERROR statement with RANKEQ
Hi all, I'm trying to make a modification to an IFERROR statement which is the following: =IFERROR(RANKEQ([Weighted Project Score]@row, [Weighted Project Score]:[Weighted Project Score], 0), "Not Ranked") This essentially runs a RANKEQ on all the entries, but if there's a score of 0 it returns value of "Not Ranked". I am…