-
Check Flag with formula
I am trying to turn on a flag with a formula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get "true" and then turn the flags back on I get my red flags, but then I try it again in…
-
How to reference the <CELL ABOVE>
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…
-
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)…
