-
Card View: Show Column Name as Label
Our workflow includes multiple check boxes in a row. In Card View we loose the at-a-glance review of the task without the check boxes being labeled. It would be a benefit for many of the column types to include what is being identified.
-
Formula with star symbol
HI, I was trying to use a formula with symbol. Here is the formula I wrote. The formula is working but I would like it to be the symbol Starred/Not Starred and not the words. My column property is symbol. =IF(Status1 = "Done", "Starred", "Not Starred") What am I doing wrong? thanks Marie
-
Turning flag red with conditional formatting
Is it possible to turn a flag red using conditional formatting? I can turn the cell background red (or any other color), but not just the flag.
-
Automating Parent Row based off RYG Children Rows
Hello! I am looking for a formula that will show in the parent row an RYG color based on the children. If there are any Red OR Yellow in the children rows, I want the parent row to show Yellow. If there are only greens (no other color), I want the parent row to show Green. How do I do the "or" statement? Thanks for any…
-
If statement for checkboxes
Hey everyone, I have project schedules with milestones that have associated tasks for each. (i.e. releasing a drawing set includes getting it stamped, sending to subcontractors, etc). I would like to make the tasks a checklist that would populate the percent complete (instead of a harvey ball), using a formula. Has anyone…
-
Card View showing all my predecessors and subtasks. How do I turn them off?
I love card view for the drag and drop ability but I only want my primary tasks showing not all the predecessors and indented subtasks as well. How do I hide them in this view?
-
Cell Linking Within Same Sheet
Hello... is there a way to link the value of a text-based cell to other text-based cells within the same sheet? I have a project plan template in which there are several fields in my "Assigned To" Contact List column which will need to be populated with the same person. Instead of even copying/pasting, I was hoping to…
-
Card View
Loving Card View already, this is a real game changer. It would be great if it had the ability not to add completed rows, for example If I mark a row/action as complete I want to keep the information in my sheet although I don't want to see all of them in my view.
-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
Link Cells - Anyway to update data on either sheet
I use the cell linking extensively, however it would be so very helpful if cells could be updated from either sheet... For example, I have a master project sheet that consolidates lines from mulitple projects in sepearte sheets. However when I want to make a change to one of the lines I have to go to that projects sheet…
