I am trying to copy and paste special/links to copied cells; however the "links to copied cells" radio button is grayed out. What am I doing wrong?
I have an internal client who wants to parse a list of 100 different zip codes, and depending on the zip, assign another text field into a different field. In other words, IF zip code = 11733 OR 11725 OR 11890 (and so on) THEN assign to New York. Maybe there is a way other than using IF? Thanks for any help you can…
Hello, I am new to the Community. I am having such trouble with designing a formula that will use two past due days for which to count. Here is what I have for the 30 to 59 days count of past dues. =COUNTIF({Audit CAP Summary Range 1}, ">=30") + COUNTIF({Audit CAP Summary Range 1}, "<= 59") It returns a number but the…
Good afternoon, I'm not even sure this can be done, but I'm giving it a shot. The picture below is a snip of the sheet I'm working on. I'm wanting to figure out if there's a formula that will put the data from a single cell on the Sep row to the "Current Month" row - but the catch is that is needs to look for the last…
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?
We are heavy users of this feature, and today it is not working. When you select an existing task or try to add a new task from an email, the circle will spin for a few seconds and then stop with no action having taken place. We've rebooted to no avail. Is this a known issue and is there an ETA for a fix?
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
Does anybody have a grant management template to share?
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?