-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…
-
Linking sheets - Trying to build off of information from other sheets
Hello! I am pretty new to the intricacies of the platform as I'm looking to lead some project management and automations for the organization I'm in. I have a sheet I am trying to build Automations into, but would like to see if anyone can walk me through how to link this information from other sheets, as they get updated.…
-
Introduction
Hi all, my name is Vesna and I work as a senior project manager in regulatory affairs for medicines. I am so excited to use the Smartsheet!
-
When will the System support a real Sysadmin role?
Apologies if this has been asked before, but what are the plans to implement a proper System Admin role to centrally manage user access to sheets, the ability to update owners on sheets and to support Security audits etc?
-
How do I get a column that shows the automated % complete for each activity?
I am struggling to get any formulas to work, I need a column that shows the percentage complete from the start date to the finish date - shouldn't be that hard but this is causing me so much grief. Every formula I find doesn't seem to work and I am not savvy enough to know how to update the formula so that it can work.…
-
Limit to number of email addresses added to a sheet for automations
Hello, Can anyone confirm if there is a maximum number of email addresses that can be added as contacts to a particular sheet using automations? I believe that number is 101 addresses. My sheet features multiple approval workflows. Each workflow can have multiple approvers, for which column formulas are used to AND each…
-
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…
-
Unable to Change or Delete Any Dates
I am unable to change any dates in my project schedule. It does not matter if it is a blank cell, automated cell, manually entered cell, new line I create, existing line, etc. — no matter what, if I attempt to modify a date, it just enters as 9/11/2025. This started last time I used my file. I have made sure cells aren't…
-
using intake form, data populates and emails me but no project is created
Title is kind of the question — why wouldn't the emailed content, a copy of data I entered to the Intake form, also create a new project on the project sheet? Thank you.
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…