Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Duration Calculation not accurate on my sheet
Duration column on my project includes Hours and Days depending on the task. However, the duration count is inaccurate.
Cell Linking for Updates?
I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists all projects, their current task, and the deadline of this task. Whenever we update the project plan, we also have to update…
Project end date - Metric
Hi I am trying to create a metric for a Sight sheet to show countdown in days and another in weeks until a project starts can anyone help ? Cheers Neil
Project Resource View -- Question about %s
I just started using Resource Management and I'm confused about what the percentages are showing. I may be missing something obvious here! In the screenshot, I have one resource who's assigned to one sheet. But the blue percentage is different from the sheet percentage below it. Why? What do the numbers indicate? I thought…
Formulas using dates
Good Morning! I am looking for a formula that will determine a specific date. I have a column "A" with a specified date and I need to set an alert or notification to be sent 45 days before that date. Is this possible? Thank you!
Gantt View - % Complete Column
I've noticed that to have the "% complete" column value show up graphically within the Gantt display, the "% complete" column MUST be a free-form entry field. I have another sheet column that uses the "Progress Bar" type. I was hoping to make the "% complete" column calculated based on the value within the "Progress Bar"…
Autofill formulas from adding a new Card
I find the value of Smartsheets to be the card view. I almost exclusively work in card view, and routinely add new items by adding new cards. There are several fields that contain formulas. Until today, adding a new card seemed to add the row appropriately at the bottom of the sheet, inheriting formulas. However, i'm…
How to auto-refresh the datamesh vlookups?
Hi EVeryone- I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need to go to datamesh website and refresh the rules my self. Is there anyway I can automate this so everytime I dont have to go…
linking to a template?
Is there a way to create a link to a template (other than using the API)? I want to put links to our templates on various sites so people don't have to remember where each template is stored in Smartsheet. Ron
Approval set up
I'm trying to set up approval emails to go to specific department leads after another box has been checked as reviewed. Process: 1.) I apply for a position. I select my position from a dropdown, say "IT". 2.) HR gets an approval email. They review my application and click approve. 3.) An email is automated to the IT…
