Discussion List
Duplicate Count
Is there a way to reference more than one column when checking for duplicates? I would like to count the duplicates from Column A if Column B has already performed work for the individuals in Column A. Additionally, I would like to only count the duplicates between a certain timeframe (e.g. 10/1/24 - 10/31/24).
Bridge - Google Translate - How to translate Smartsheet Form?
Hi, I just got Smartsheet Bridge and I am still trying to learn how to use it but the resources are very limited. I have global users who use Smartsheet Form to submit survey. We face a challenge with a language barrier and I would like to utilize Bridge and Google Translate and give them the option to translate survey…
Scenario planning for Resource Capacity Management
Currently it is very difficult to do resource capacity planning for different scenarios across a project portfolio. The People view does not recalculate the resource allocation percentage when filtering projects so. you cannot see the difference when excluding a project. You also cannot try out different scenarios where…
Resource Management panel icon - not appearing
Hi, I'm wanting to start using 'Workload tracking'. I've read the learning resource below and set up a new project sheet, however the 'Resource Management panel icon' just isn't appearing. This panel appears to the first step to setting up Workload Tracking. I've reviewed the Smartsheet community, but can't find anything…
How can I access Table view?
Cross-Sheet Dependencies
Effective management of project programs demands careful consideration of inter-project dependencies since tasks in one project can impact or rely on tasks in another project. We kindly request information about your plans for introducing cross-sheet dependencies in Smartsheet. Could you please confirm if this feature is…
Send as Attachment - Recurring Schedule
Hi, I have a question regarding the Send as Attachment Feature. I want to send the entire grid as PDF to certain people but It seems like it will only capture all the data that is in the grid for that certain day when you set it up. Is there a way for smartsheet to send the most recent updated grid daily via this feature?…
Template for employee time tracking, automated report for clients and accounts, and dashboard
Hello community members We work on several projects where we have to maintain timesheets for all employees. Is there a template that I can repurpose to enable my employees submit their work hours under different projects and have some kind of weekly and monthly reporting in place for clients and accounts? Some kind of…
I need some help with a calculation. I am hoping you can help.
I need to have a column calculate the status of a project based on where today stands compared to its % complete and where we are between the projected start and finish date. As an example. This is what is entered manually. Start End % complete Project status 01/07/24 22/11/24 92% In Progress - On Track Today is Oct 18th…
How to Get a Balance Column to Show the Balance Remaining in Each Row
I am trying to create a budget sheet which shows the remaining balance for each line. Here are my columns: Order: This column has the following formula =MATCH([Row ID]@row, [Row ID]:[Row ID], 0) to allow me to move around items to better fit the budget balance for each period. Row ID: This is the auto-numbered smartsheet…
