-
On Screen Alert if Conditions Not Met?
Is there a way to alert the user when, for example, they check a box, but other conditions are not currently being met? I see I can send emails and Slacks and whatnot, but I just want something to appear on screen. Thanks!
-
Countifs not calculating as expected
Whenever I change a field to NA it should exclude counting it into the average but it is not doing that. It is staying at 50% but should be 100%. Please let me know what I need to do. See screen shot. =(SUM(Yes4, Yes6)) / ((COUNT([Department - ie: Sales Eng, TDE's etc]4, [Department - ie: Sales Eng, TDE's etc]6)) -…
-
Share a sheet to all company employees
Hi, we would like to share an inventory sheet to all of our company employees and I'm searching for a solution that will prevent the fact that I need to type every single email addresses into the share function. Does anyone has an idea on how we can do this? thanks
-
Multiple Projects into one Summary
Hi all, I am trying to set up a workspace to help manage multiple clients via projects. I have set up a template set for each project that includes plan, dashboard, key reports. My next step is trying to to roll up each project sheet into one summary for management. I was able to add a checkbox to each template so I can…
-
Editors can't attach files
Hi, I have a grid that is shared with a lot of people. Some of them Admins and some Editors - Can share. From some reason, in the last few weeks all editors can't attach files to rows any more. Does anyone have a clue what could be the reason for that? All editors are not licensed users if that makes any different. Thanks!
-
Formula for status
Hi, Can I please have help with a formula. I want to show in a status column the following status': Current - if expiry date hasn't been reached Expiring Soon - If expiry date is in the next 60 days Expired - If expiry date is today or greater than today Column name for Date is "Expiry Date" Thanks, really appreciate any…
-
Besoin d'aide au sujet des rapports
Bonjour, Est ce que l'un d'entre vous a déjà crée et partagé des rapports, via smartsheet? Si oui, Faut-il obligatoirement partager la feuille source des données afin de visualiser les informations dans le rapport ? De mon côté, je souhaiterais ne pas partager la feuille source des données, mais uniquement le rapport.…
-
Tasks in Resource View
Is it possible to view the task or sub-task assigned to a resource in a resource view? We use a multi-project sheet to encapsulate schedules and would like to track resources within a sheet as opposed to across sheets. As you can see in the screenshot, the resource view only shows the sheet name instead of the task, which…
-
Copy Paste from Google doc
Pasting content (plain text - even a single cell) completely destroys Smartsheets and has to be refreshed/reloaded.
-
Formula to count values in a column
Good evening VERY NEW to smartsheet. I am creating a metrics sheet for data we want to capture on another sheet. How do I get the QTY of "beam" counts in this column? Thank you