-
Issue with CountIF/AND
Hi all, I am running into an issue with using CountIF and AND. What I am trying to do is count the number of times certain text appears within a 90 day period (based on submission date which is a date column). =COUNTIF(AND({External Range 1}, "Zebra", (TODAY() - {External Range 5} < 90))) I am getting "Invalid argument…
-
Cannot use Outlook Plug-in - Is there alternative (e.g., email address to turn emails into tasks)
Unfortunately my work email address is on-premises Exchange Server so I cannot use the Outlook Plug-in (very disappointing as that would simplify my world tremendously). So far I have not seen an alternative such as a unique email address I can forward emails to auto-add to tasks in smartsheet (such as other productivity…
-
Dashboards (sights)
Hi All, I'm wondering if anyone can help me out. My current client has one program where each staff (4 in total) each individually have their own projects. I created a sheet for them to use that has these columns: Task Name. Start. Finish. % Complete. Status. Assigned To. Done. Risks. Risks & Issues. The staff go into…
-
Issue with CountIFS OR
Hi all, I am running into some trouble iterating on this formula which was a countifs with an "AND." I am now trying to add an "OR" to the first part. I want to see if the Range 1 contains "Zebra" or "Lion" and was entered in the last 90 days. After scanning these communities, I have tried this three different ways and…
-
Sheet/Report Limitations?
Hi everyone! I was wondering if this scenario is possible for sheets either using formulas or commands. Example, I have 3 sheets (pipelines) that lead to multiple reports. I have jobs ranging from 0-100 (intervals of 20) percent probability(of selling/sold) in the pipelines. I currently have reports that group the…
-
Report Enhancement Request
I would like to be able to reference filter criteria for reports from a single top level cell. My project and workaround/issue is below: I am in the manufacturing business. We have machining lines that have a number of operations: ill say on average its ~20 operations. Each operation has an operator that at the end of the…
-
Resource View issue
Hi, I would like to assign a resource to a project but the user name not appear on the enterprise list or my contacts list. If I add the user to my contacts don´t appear on the resource view. What could I do for this? thanks for your support
-
Tracking edits of one column only
I'm trying to track when end dates are changes in the project plan. I've added a system-generated column that will show when a whole row is modified, any way to limit that to one column? I need reporting capabilities that aren't possible with the activity log or cell activity functions. It also would be great if there was…
-
Rounding Up to nearest 50 or 100
Hi all, I'm trying to round up to nearest 50 or 100 in a smartsheet. So far, I have =IF(AND(Count1 < 50), "50", ROUND(Count1, -2)). However, this only account to values less than 100. I was hoping anyone could help me for values over 100 (i.e. 101 is rounded to 150 and 155 to 200).
-
Report Frustrations from SmartSheet
I have been using Smartsheet now for about 2 months. While I love it for so many reasons, I am frustrated too. I love being able to run the reports, there are so many great filters......why don't they just allow a function to add totals to the reports. Hence, when management asks me to report the sales numbers based on…
