-
Circular Reference / In Excel it works / SOLVED
This has been solved now :) Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. Saves some 30+people now a lot of work. Hi there, we are stuck transforming some sheets…
-
Daily metric widget problem in dashboard
Hi, I have a problem with a metric widget I would like it to show me the row that is for current day. Is there a way of doing it or do I have to make a report.
-
IF(AND( and IF(OR(
Hi All! I feel like I have been reviewing every community post about the IF(AND and IF(OR statements within a function but still can't seem to figure out what I am doing wrong. =IF(AND([Resolution Method]3 = "ClinOps F/U", [ClinOps Resolution Description]3 = "", IF(OR([Additional ClinOps F/U Needed?]3 = "Y", "Yes", ""))))…
-
Function/Formula help to input Yes/No values as well as days outstanding based on two different scen
Hello, Can you please help me figure out formula's for the follow scenarios? I have attached a copy of my smart sheet that i'm needing to apply the formulas to. #1) PC Action w/in 5 days (Column F): If the date in column D (Date 1st update provided by PC) is less than or equal to the date in column C(Due Date) then YES…
-
Combining 2 Formulas
Hi, I am having trouble combining these 2 formulas: =NETDAYS([Date Sent To Rep]@row, TODAY() - 1) =IFERROR([Over Calc]@row, "") Right now I have 2 separate columns calculating, but would like to have just 1. Is it possible to combine these 2 formulas? I want it to calculate the net days, but if there is not a date inputted…
-
Toggle Hyperlinks
I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., tim@ourcompany.com) or external (i.e., one of our customers - e.g., bill@clientcompany.com). Is there a way to do that via a…
-
countifs formula help
I am trying to Count # of tasks if the task meets multiple criteria. For example, the task is green, it happened in the 2 quarter and it's in the metrics workstream. I get an Invalid Ref error in the formula. I am only counting tasks from the same sheet. Formula is below: =COUNTIFS({Health}, "Red", {Quarter}, "Q2",…
-
Autofill field using the IF function
Hi I have two columns. One is called "Hierarchy" and the other is called "Description" I'd like to have "Description" automatically filled with this text/forumula "=PARENT()" if the value in the Hierarchy column is "2" Can this be done using the IF function or through another method? Thanks
-
Smartsheet Forms - Apostrophe automatically added to formula
Hi All, I've just started creating a Smartsheet form for people to easily add data however one cell should just be a formula so I'm using the 'Default Value' under field options but when the form is submitted an apostrophe is automatically added to the front of the formula rendering it useless without editing it. I've…
-
formula to check box if attachment is uploaded
I wanted to create a formula to check a box if an attachment was uploaded on a row but I haven't run across this function yet. Does smartsheet allow this?