-
Countifs using iferror or iserror
Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 value but I want it to return a value of 1 for each error. This is the formula I've been…
-
Tracking Time (Tasks)
Greetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if there's any advancements in this arena recently. Regards, jc
-
Cross-sheet formulas
I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there. I have a couple of questions about the best way to use the new…
-
Sum of each different categories in on one column
Hi, I have 2 columns, one with a product description(Different products on a 1000 cells) and the other column it is their individual value. May you assist on how to get a sum of, say "shirts" only from the product description column?
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Reports Not Updating
I'm having issues where my reports are not updating. Is anyone else having the same problem?
-
How to track items that are completed after their due date
Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. =IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Merging two smart sheets
I'd like to merge 2 smart sheets. I have column headers and row info that I would like to add to existing rows on a separate sheet. Is there a way to just add these new columns to the back end of the existing sheet (all at once) instead of having to create new ones all together? I'm new to smart sheet
-
Inquiry about smart sheet
Hello I am trying to figure out how to add calculations option to customers sheet. Can anybody help me regarding this? Thanks.