-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue). I want to create an automated reminder for…
-
Driving Change with Smartsheet: Strategies for Successful Adoption
Dear Smartsheet Community, After many conversations with fellow users, I've noticed a growing need to support the Smartsheet community with change management. Common Challenges: Difficulty gaining leadership buy-in or achieving widespread Smartsheet adoption within teams Struggling to align leadership on shared goals and…
-
Should Smartsheet Reconsider Pricing Policy for Live Support?
Would anyone else like to see Smartsheet reconsider their pricing for users that need live support? I manage creative services projects for a large healthcare organization and am one of only a couple users that would ever need support. As a not for profit, it would be a waste of money for our organization to buy support…
-
Limited Capacity on Sheet and Loading Time
I manage creative services projects for a large healthcare organization, we use one sheet that has several linked reports. Loading time is slowing due to the large number of cells and I will need to move rows. I have asked this question to the SS support team several times and have not gotten an answer. “Could you please…
-
Merged: Enhance Dynamic View with Grid, Calendar, Board, Gantt, and Card Views
This discussion has been merged.
-
Smartsheet Implementation: Overcoming Common Challenges in Change Management.
Hi everyone, I wanted to share some insights on how we’ve been using Smartsheet to tackle some of the most common challenges in change management. Whether you’re dealing with leadership alignment, struggling to keep projects on track, or facing difficulty engaging teams during a change process, I’ve found that having a…
-
How do I overwrite or replace a sheet which is linked with multiple reports/reference sheets etc,.
I have a master data file which has around 20000 rows with nearly 10 columns (200000 Cells) Data driving several reports (50~60), reference formulas to several sheets (8~10). Master Data file changes (200000 Cells) everyday (Adds/Removes/Re-arranges data). In excel, we just save the file under the same name and it gets…
-
Workspace permissions based on Admin level?
As an Admin level permission in a Workspace, can I create new Sheets, Forms, Reports, and Dashboard in the Workspace? I'm testing it out and it seems like the Owner of the Workspace is the only one able to create new Sheets, but I was wondering if I was missing something since I thought that the Admin level would also let…