-
Multiple IFS for calculations
Hi, I have no problem doing this in Google Sheets but I'm not sure how to do this in Smartsheet. I have columns that contain THC and CBD content, measured in a number of different ways, including percentages, mg, percentage ranges, etc., but they're always consistent units of measurement across the row. I need to calculate…
-
Formula results varying between today and yesterday
I have a formula pulling info from another sheet. This then feeds into a dashboard metric. The formula is a COUNTIF for anything with today's date. What is happening (and this sounds crazy....I had to get a couple of people to observe it to confirm it wasn't just me) is that at some moments in time the figure on the…
-
Flag out of Range Date
Hello, I have a date range: Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End. Can anyone help? I've tried: =IF([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Count only outstanding items
I have a Request Management sheet with a Form that we used to track tasks. They template came with a Metric sheet that is very useful. One of the metrics on this Metrics sheets counts items by assigned person. I want to update that to count only items that are not Closed status. Current formula is: =COUNTIF({Request…
-
25,000 cross-sheet references limit
I use a lot of cross references in my sheets. In one sheet, my blue arrow references have got the error code #CALCULATING on them which I know is because I must have gone over the 25,000 limit. I've archived about half the rows though and I'm still getting the same error. What am I getting wrong...? :(
-
Cross-sheet references
I'm getting the error code #CALCULATING, which I think is because I must've gone over the 25,000 limit for cross-sheet references. The sheet originally had upward if 4500 rows and I've removed more than half of them now but I'm still getting the same error. Can anyone help with this please?
-
COUNTIFS with reference to another sheet more than one criterion
I'm very confused about this function. It has an #UNPARASABLE error. =countifs({Jade2_BCM Dashboard 2019 Range 1},"Complete",[{Jade2_BCM Dashboard 2019 Range 2},"Business Resilience",{Jade2_BCM Dashboard 2019 Range 3},"1st Quarter") I am trying to reference three columns from another sheet, Jade2_BCM Dashboard, to see how…
-
Formula for common end date
I'm trying to figure out how to have several tasks point to a common end date. The tasks have various implementation dates but the "go live" time period ends at the same time (i.e., 2 tasks - one completes on 6/13 and the other completes on 7/1 but the project end date is 12/31 for both...so different durations and I don't…
-
General coding/formula questions
When coding issues get beyond the incorporated realm of Smartsheet, such as in my recent post about time/date stamping, it is my understanding that Zapier, Smartsheet API, or compatible languages come into play. So, what are the opinions in the community about this. Do most folks incorporate a conglomerate of apps or stick…