-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying to…
-
What formula to use to count all instances of a value across multiple columns.
Hello, My colleagues have set up a sheet to help them track sustainability actions in their department. They've asked me to help with setting up reports and a dashboard that summarise and calculates the types of actions across the 4 Action type columns, as well as summarising further by team. As you can see there's been an…
-
Wacky Start Date When Using FF in Predecessors
Hi there, Working to update a plan today and I noticed that the use of the FF Predecessor Type will cause some weirdness with the start date. I've put an example in the graphic above but the summary is this: If you have two tasks that have the same duration and you want their completion dates to line up, the start date for…
-
Best Way of Being Able to Display Data Using a Current Sheet, Archive Sheet and Summary Reports
Hello, I'm assisting some colleagues with a solution that helps track music session bookings. There are a number of summary reports set up, which the metrics are then displayed on a dashboard. It's been set up for exactly a year, but they only want the current financial year's data to be displayed. They came to me asking…
-
Filter default
Is there a way to save a filter as the default. I want the same filter applied every time the sheet is opened without the need to select it.
-
Free User can't modify Sheet
Hi All, I have shared a sheet with an unlicensed use with the role as "Editor - Can Share", but it can only access to the sheet in Only View mode and it cannot edit. What i'm doing wrong? I have a Pro Plan. This is a test user with my personale email that i've invited without a license. With this user i can see the shared…
-
Free User can't modify sheet
Hi All, I have shared a sheet with an unlicensed use with the role as "Editor - Can Share", but it can only access to the sheet in Only View mode and it cannot edit. What i'm doing wrong? Thank you in advance, BR --Dennys
-
MEDIAN() Column formula keeps breaking.
Hello Smart people, I have a solution that uses four sheets. The first, is an export of vehicle assignments from a vehicle management system. Data Shuttle overwrites all data in this sheet at 12:00AM each day. The second sheet (Daily Rental Summary), is a sheet to aggregate daily totals. A workflow adds a new row to this…
-
Do group admins have to be in a group?
Hey there, I have made groups that I want to continue to manage, but I do not want to be a member of the group. Smartsheet seems to add the group admin by default and when I delete myself from a group, I reappear. For example, I want to make and manage an HR group, but I am not in HR. However, since I am the group admin, I…
-
Automation Workflow Not Consistently Working
Hi! I set up an automation workflow on a form I created in Smartsheet. I have tested it twice; with one group it worked and each person received the email notification to approve or deny, however, the other group no email notifications were received to take action. I did not update the workflow between test groups and the…
