My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range f…
We have just onboarded a customer that we want to track their IT service tickets using Smartsheet. There are two key Service Level Agreements that we need to managed to. The customer would like automa…
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new work…
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 4…
Been using SS since 2016 and have never had a delay send or non-received notifications. My entire company today is not receiving the regular email notices. Is anyone else experiencing this issue today…
Hi - I'm looking for a formula that will display "All tasks complete" in the Parent Status cell, if the Status of all Child tasks is set to "Complete" (and will display "Incomplete Tasks" if any Child…
Is there a way to set a password change policy? For example, I want people to change their passwords every 90 days. Can I set that to happen automatically?
Hello everyone, I have been googling this for a while, and decided it would just be easier to sign up for the forums and post my question. What I am trying to do should be a simple IF function stateme…
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Shee…
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the we…