-
COUNTIFS Formula in Sheet Summary Returning "#NO MATCH"
Hi all, I had a formula in place yesterday that was working fine, but this morning is returning no match. In our sheet summary, I am trying to count the number of quarantined individuals in a specific market. Here is the formula I was using: =COUNTIFS(Market1:Market1832, ="NE/IA", Quarantined1:Quarantined1832, <>"") The…
-
Is there a way to deal with "maybe situations" or varying predecessors?
Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but only on an as-needed basis dependent on results. For example, we anticipate product A will need 4…
-
How do I view the list of Support tickets I have submitted
Hello everyone, being a newbie on submitting Support Ticket, I was wondering if anyone can help confirm where I can view the list of tickets I have submitted to Support - hopefully with the status as well. Anyone have experience in terms of their turnaround time ? Thank you.
-
Collaborator Name not Recognised When Trying to Apply a Filter in Activity Log
Hi, when looking at the activity log for one of my sheets I can see the names of the collaborators the sheet has been shared to. However, when I try to filter on one of the collaborators I'm met with the error message "Unknown User Entered". It doesn't matter if I use their christian name, christian name & surname, or full…
-
Summing up the values in a row
Hi, How do we sum up the total value of numbers in cells in a row? Everytime we add a new value in the row we want a total
-
Where is the COVID-19 dashboard
Hi all, In the press I read that Smartsheet has released a COVID-19 dashboard for the community - https://www.geekwire.com/2020/smartsheet-q4-revenue-51-78-5m-heres-company-responding-covid-19/ Where can I find this? Thanks, Victor
-
Form not updating the Worksheet
Hello everyone, I created a Form from an Excelspreadsheet I imported into Smartsheet - it's an issue tracking list. I can complete the Form data but the information entered in the form do not seems to appearing in the Worksheet itself. Appreciate if anyone can shed some light as to where the above issue could be. Thank you.
-
Resource View Missing Resource Information After License Purchase / Activation
Hello everyone, I just complete the purchase of Smartsheet and received the license activation last night. Prior to the purchase, I used the trial version to create a bunch of Project Plan / Sheet as well as assigned resources to them. During the trial, I could see the resource views showing the list of people, which…
-
Cross Reference Cell limit
Hello, is there any news on increasing the 25000 cell limit for cross referencing?
-
Limitations to a sheet?
Hello, I'm in the process of automating a tracking sheet, and it will no longer allow me to copy and paste the formulas into the rows- see screen shots below- it stops at row 1400 The formulas are: =IF(ISDATE(Start1375), "Complete", IF(ISBLANK(Start1375), "In Progress")) =IF(Status1375 = "in progress", [Panel S/F]1374, 0)…
