-
Unticked boxes to trigger reminder dates
In my project sheet, I have a Task Complete tick box. I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date. Is this possible?
-
Using check boxes and flags in formulas
In my project sheet I have checked boxes and flag. I would like to include them in my formulas. Example: If the box is unchecked by X date then the X date will appear in a reminder column.
-
Can we please include widget for including iframe ?
Smartsheet community, I have tried smartsheet labs for the charts and have a live iframe to be embedded in the Dashboard but there is a no widget to include iframes. can we include this and do we have better options for charts and dashboards in smartsheets as i feel still a long way to go for better dashboards in…
-
Creating a Milestone
I would like to create a milestone where it is within a timeframe I decide to setup. For Example if I put the Start Date as 5/15/18 and a target date of 5/23/18 how can I go about doing this so we can see a milestone.
-
Multiple Project Task List Roll Up
Hello, Is there anyway to have a project task list that is updated from multiple project task list sheet? We are looking to have a master roll up of the Project Milestones without including all the tasks on 1 task list. Thank you
-
Cell linking report sheet linking
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new workspace or folder for each project. I am hoping there is a way to make the project/sheet links stay within the…
-
Is there a way to Center things on forms
Is there a way I am able to center the headings and information or does it always have to be on the left side of the form. I have attached a copy of the form I am using and now I want to be able to center all the information or move around things on the form to have it linear where an email address and phone number would…
-
Convert decimal back to hh:mm
Hi, Any help would be greatly appreciated. I am trying to calculate the following: Start Work Time (input) First Break Start Time (input) First Break Finish Time (input) Second Break Start Time (input) Second Break Finish Time (input) Third Break Start Time (input) Third Break Finish Time (input) Work Finish Time (input)…
-
Inserting a Formula into an existing Equation
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number "60" with…
-
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…