-
Can this excel formula be created in smartsheet?
=IFS(A5>B5+C5,"RED",B5>A5+C5,"Green",C5>B5+A5,"Yellow") If anyone can help me I<d be very appreciative :)
-
COUNTIFS with an AND or and OR?
=COUNTIFS([Actionee - SAP]:[Actionee - SAP], "Jess Smith") OR [Actionee - As-Builts]:[Actionee - As-Builts], "Jess Smith") I am trying to count the number of times Jess Smith appears in columns Actionee - SAP and Actionee - As-Builts. I keep getting unparseable. Looked at many threads and cannot find a countifsโฆ
-
Red Flag If Statement and Children function
Hi All, first of all, I am new here, so thanks for every help in advance. I did do some research in the forum and tried to figure it out myself, even trying to adapt similar codes to mine, but just couldn't figure out a solution that works. I have a "Task at Risk" Column that shows a red flag when the task will be do theโฆ
-
SUMIFS with NOT CONTAINS as well as no blanks
I'm trying to create a formula that sums the duration only if there is something in the Assigned to column. I keep getting #INVALID OPERATION. What am I missing? Thanks in advance! =SUMIFS(Duration:Duration, [Assigned To]:[Assigned To], NOT(CONTAINS("Client", @cell)), <>"")
-
If Blank in formula Help!
I have setup a formula =IF(AND([WO # if applicable]@row = "N/A"), "No", "Yes") in a Notify Process Docs column, that when a N/A is entered into the WO # if applicable column returns a No value. Any other value will return it to Yes, triggering a notification to be sent to certain individuals. I am struggling on the formulaโฆ
-
Can you use a CONTAINS formula within IF(AND statement?
Hi, I have 2 sheets: 1 sheet is a grid of names and owed hours and the second sheet is a grid in which overtime is approved (A form is used to populate this) I would like to highlight on the overtime sheet if someone has owed hours, This way overtime is not approved before the owed hours has been used. As the overtimeโฆ
-
INDEX() MATCH() Formula with some cells containing multiples items?
I am cross-referencing sheets to auto-populate the [Assigned To - Organisation] column in the {Action Tracker} sheet. I utilise the values in the [Assigned To - Individual] column to extract the Organisation from the {Project Directory[Organisation]} sheet/column. I have achieved this using INDEX, MATCH formula, see below,โฆ
-
Countif and an And!
Hi, got this far.... =COUNTIF(AND(Actionee:Actionee, "Jess Smith"), [Target date for updates]:[Target date for updates], <=TODAY()) Think I either have brackets or commas wrong! in essence count records where Actionee is Jess Smith and Target for updates column has date less than today. Thanks in advance, Paul
-
SalesForce connector workflow...can't do "or"
SalesForce connector only allows for Filtering Operator 'AND' and Not 'OR', is there a workflow for this? I need to filter on two different fields but need OR instead of AND i.e. Business Influencer includes xxx OR Solution includes xxx
-
Smartsheet Hyperlink to a Specific Cell in Another Smartsheet
Greetings! Seeking this team's help with the creation of a hyperlink from one Smartsheet cell to a cell in another Smartsheet. Attached is a brief example of what we are attempting to accomplish. Smarsheet A has a client list. Next to each client, we have the name of the price list the client is invoiced against.โฆ