-
Lookup reference in another row referenced
Hello, Possibly this cannot be done in Smartsheet. I am trying to port over our drawing list coordination sheet from excel to Smartsheet. The formula uses Lookup in Excel - actual revision number to find on the same row that number - then return the date of that column from the first row of the sheet. The excel formula is…
-
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…
