-
Formulas in Reports/Reference reports for Dashboard
I read in the community (the posts were a few years ago) that you cannot enter formulas into reports or that you cannot reference reports for a dashboard. Is this still the case? I having living data that really needs to be manipulated to get it prepared for a widget. I'm new to smartsheet and it seems like reports are the…
-
If date is less than, greater than, or blank formula.
I am creating a formula that will display Completed, Upcoming, or Prerecorded based on the dates in Column 2021 Session Dates. When I use the formula below, any row with no date comes back as Completed even though I have added the IF ISBLANK formula to output Prerecorded. I don't get an error in the field, just not getting…
-
A formula pulling Time from a System-Generated column does not stay consistent. Please help!
I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours. For example, the screenshot is showing it accurately. But it will randomly switch to…
-
Sumif formula with multiple criteria
I’m trying to write a formula for a dashboard rollup sheet and am having some difficulty. This is what I have written but it comes back incorrect argument. =SUMIF({2021 FLS Small Project Tracker Range 1}, "Reserve Fund", {2021 FLS Small Project Tracker Range 3}, "Apparel", {2021 FLS Small Project Tracker Range 7}) I want…
-
Advanced Filtering by MAX value
Hi all I've created a report and wanted to know if there is a way to show unique rows by the highest date value For example - below I would like to see the bottom table as my report (colours are just to show the matching rows - they are not part of the conditions required) where only the unique rows are pulled through…
-
COUNTIF Formula Only Works on Certain Rows
Hey Smartsheet Community, I am currently being stumped by this formula that for some reason only works in a few rows. It is a COUNTIF formula that is counting the number of assignments each person has. I will paste it below: =COUNTIFS({Resource Name}, FIND([Qarbon Owner]@row, @cell) > 0) I have 29 people that I need to…
-
IFTEXT vs something for numbers not just text
Hello Community, I am using an IFTEXT function to automatically check a box in one column if the cell in another column(s) has text in it. I also need it to check the box when the other corresponding cells have, not only text, but numbers as well. Is it possible to combine the functions to allow for an "OR" command that…
-
Creating a formula that uses the output of a formula in another column
I have column that generates a True /False answer using the formula below: =IF(ISBLANK([Published date]@row), "", (IF([Published date]@row <= [Date due]@row, "True", "False"))) I want to work out the percentage that are "True" in a separate column. The formula I had created stopped working a while ago and shows as #INVALID…
-
Trying to Count how many times a specific date populates
I am trying to count how many times each of of the dates in 'Clean Up Date' populate so I can set up a notification to deactivate the form that feeds into this sheet after 8 people sign up for each date. I've tried typing in CountIF formulas referencing similar questions asked in the past but nothing is working. I even…
-
How to Incorporate Durations in COUNTIF formulas with Calendar App
Hey all, I am having issues rolling up calendar availability with the durations. If you look at the calendar attachment picture, I want to have 3 jobs scheduled for 7/17/21 but we have a job with a duration of 2 days the day prior which makes it more like 4 jobs scheduled. I have a cross-sheet reference off the main…