-
Counting number of items from a specific month with multiple criteria
I'm trying to count the number of items that were published for each LOB in our operation during each month. I've tried a dozen different formulas, but I can't seem to get any to work. I currently have a sheet summary with the following: =COUNTIFS([Received Month]:[Received Month], IFERROR(MONTH(@cell ), 0) = 1, (LOB,…
-
Building a CRM to track current and future business contacts
Good afternoon, I work at a community college and we don't currently have a CRM solution that will help me with the work I am doing. I am trying to create something to track current and future contacts on an organizational level as well as individual. One company might one contact only but in the case of a large…
-
Cross-sheet formulas not returning all results
Hi- I am trying to link data between 2 different sheets. I created an INDEX/MATCH formula to pull in information related to "Phase" from a Master sheet into another sheet. I am using a unique code to link the information. The formula is only returning 8 results, and returning no values in places where I have verified there…
-
Merged: Enhanced Report and Sheet Filters for Dates
This discussion has been merged.
-
Dynamic View Link Access for Non-Smartsheet Users
Hello, If I send a link to my contact list (using an automation workflow) of a dynamic view I created, will the contacts that that currently don't have a Smartsheets license be able to view that link?
-
Timeline View (Reports)
Hi, Is there a plan to provide the option to manually re-order the swim lanes in timeline view? I am using a report that pulls from several sheets and it would be helpful to have this option without creating helper columns in each of the source sheet to do so. Additionally it would be helpful to have the "fields shown"…
-
Os meus editores não conseguem editar
Possuo o plano executivo e, até pouco tempo atrás, meus editores conseguiam realizar edições normalmente, sem a necessidade de vínculo como membros pagos.No entanto, nas últimas semanas, eles não têm mais conseguido editar, o que tem impactado negativamente nossas entregas e gerado baixa eficiência nas demandas. Você…
-
Lag in Dependencies AND elapsed days in the Duration
There has been a recent change within the last month or so that caused rows that were using lag in the dependency AND elapsed days in the duration column (which is an INCREDIBLY common occurrence in our project plans). This recent change has now messed with all dates both past and future that are either directly or…
-
smartsheet status help
I always receive this pop up when I am using any cross sheet referencing or dashboard. how to sort this out? Is there anything like trouble shooting in smartsheet as well. Please help.
-
View Only account
Hi, I have paid my monthly fee and annual few but i still get a view only error