-
Successor Column Issue
I am having trouble with adding a successor column. I have pulled up the example project plan and added =JOIN(SUCCESSORS([Task Name]@row),”,”) to my Successor Column. I keep getting an error (#UNPARSEABLE). Task Name is my primary column. I have tried other columns (Start, etc.) and I have tried without the [ ]. I am…
-
Formula help
This discussion was created from comments split from: Birthday/Anniversary Formula & Reminders.
-
Hours and Minutes calculation
Hi, I have a Start Time column and an End Time column and I would like it to calculate the hours and minutes of duration into another column. I scoured Smartsheets and found information on this, see link below, but when I try the formula, which should give me 0 hour(s) and 45 min, I get 0 hour(s) and 4500 min. Can someone…
-
Using Formulas with cross reference sheets
Hello, I need help adding one more criterion to this formula I am using to pull data from one sheet (Budget) and give me a total expense in another sheet (Staffing). =SUMIF({5320182 VENDOR}, @cell = [Last Name]@row, {5320182 EXPENSE}) This formula is pulling the data fine but I need to narrow it down one more time by…
-
Is there a Formula I can write in a cell to pull in the ATTACHCOUNT or the ROWID etc
In ODBC export I can see the following which I could use to create custom URL's to a specific row, and filters based on HasAttachment or not. The PowerBI Connector doesn't seem to pull these fields in? Is there a Formula I can write in a cell to pull in the ATTACHCOUNT or the ROWID etc
-
Compare two cells with comma separated values and return the unique values from the comparison?
I am trying to compare two cells with comma separated values in Smartsheet and return only the unique values. See below for an example: In excel I am able to accomplish this by using the following formula =TEXTJOIN(", ",TRUE,UNIQUE(TRANSPOSE(TEXTSPLIT(TEXTJOIN(", ",TRUE,A1:B1), ", ")),,1)) Is there any way to do something…
-
Average IF Formula
I have a column (Completion Date) and a column (Approved Budget). I am trying to find the Average Approved Budget for 2021. This formula works for budgets after 2021. =AVERAGEIF([Completion Date]:[Completion Date], >DATE(2021, 1, 1), [Approved Budget]:[Approved Budget]) But, I cannot figure out how to get the formula to…
-
I'm getting incorrect calculations for this simple formula.
I'm trying to calculate the "Net Balance" with this simple formula but I'm getting incorrect calculations. Current formula: =[Gross Amount]@row - (SUM([Deposit Amount]@row, [Credit Amount]@row, [Discount Amount]@row)) I have tried using VALUE and SUM too but with that I get incorrect operation error. Can someone please…
-
COUNTIF & COUNTIFS Formulas
Hi All, I'm needing help with some adjustments to the formulas below: In the Total Count formula, I'm trying to count only the number of times each country code occurs, but the 2nd criteria is that the value "Outside of the US" must also be present in the "Request Type" column. TOTAL COUNT =COUNTIF({Country or Territory…
-
Auto update % complete
I have the total number of parts I need to produce and one for how many parts I have completed. Why can't I have a formula that will update my %Complete column and have it reflected on my Gantt chart? This seems like this should be something that we are able to do but for some reason, Smarsheet doesn't allow formulas for…