-
SUMIF sum of the number of cells meeting a text condition
I'd like to add up the number of boxes with the same condition. For example, in column 1 I would like to count how many times I have the word nature. When I use SUMIF to do this it doesn't works.
-
Automatisation par rapport à une colonne de date sur smartsheet
Bonjour à tous, Je souhaiterais, dans le cadre d'un projet de suivi d'entretiens, effectuer une automatisation par rapport à une colonne de date sur smartsheet. Je souhaiterais que la colonne "Retard" indique "Oui" dans le cas ou la date de la colonne "Prochain entretien" soit dépassée. Dans le cas ou la date "Prochain…
-
Attaching docs to smart sheet makes it slower?
As I attach documents to rows of my smartsheet, does that make opening the sheet slower? Or does it affect the performance of my smartsheet in any way?
-
How to make a Workapp public?
This discussion was created from comments split from: Is there a way to make part of a workspace public?.
-
Link Resource Management "Phase" of a project to data in Smartsheet
It would be useful if a project's "phase" could come from a cell in Smartsheet so the phase of a project doesn't need to be updated in two different places. Example: A project moves from Planning to Execution. As a PMO Manager, I would like to be able to update that in the Smartsheet Portfolio Rollup Sheet for that…
-
Sorely needed = proper, granular zoom levels in Gantt chart view!
For years I've suffered with the ridiculously coarse and uneven zoom levels in Smartsheet's Gannt charts. No more, I'm now raising my hand to say it's 2023 and we should have far more granularity in zoom levels on a Gannt chart view! Ideally a zoom slider tool (like, for example in MS Word and Excel) rather than fixed…
-
I am an editor on a smartsheet but can't edit the sheet
Hi, I would appreciate your help. I am assigned as editor on a sheet by the Admin, but I can't edit the sheet. I have logged out and back in. I appreciate your assistance. I even opened smartsheet in a different internet browser.
-
Automation of additional line items and events once original event date created
I am trying to create a detailed calendar for my team. I would like it so that when I create an event, depending on the event type, Smartsheet knows to create additional events on certain dates before and after this original event. I would like the rows to be added automatically to the sheet once the original event is…
-
Sheet Summary Formatting - Sections with Headers, Dividers
I use sheet summaries often to help my team quickly see what the overall metrics are for a given sheet. I wish you could format the sheet summary to create sections. If I'm measuring three different types of metrics on a single sheet, it would be wonderful if I could create sections within the sheet summary for each of…
-
Time tracking in Resource Management at the Task level in Smartsheet
We would like to be able to track actual time against the task level of project/sheets setup in Smartsheet, in Resource Management. Currently I can see the tasks in Resource Management, in the Work List of the project in Resource Management but I cannot track actual time to those individual items. It is critically…