-
Gant Chart Export
Hi all, I am wondering if anyone can help me with an issue I have regarding exporting the Gantt chart. For example, when I create the plan and add all the required elements and select export this to PNG. I am presented with a low resolution, very small gantt chart which does not include all of the details. Ideally I want…
-
Usage of [ ] symbols and ( ) in formulas.
Hello Smartsheet community: In the attached picture, why "Task Name" variable needs to be surrounded by [ ] symbols while "Cost" variable does not? Thank you. Jon
-
dates changed in bulk
One of my editors mistakenly indented more lines that they intended to, but when i moved them back out all the dates changed. I have corrected each one using the cell history, but without understanding how it happened in the first place. Help!
-
Nested IF formula using additional AND/OR logical functions
Hello everybody, I am struggling with creation of formula for defining Invoice Status Symbol (RYG). Geeting the UNPEARSEABLE error message. My formula is right now as follows: =IF(TODAY-[INVOICE DUE DATE]11>30,"Red",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),"Yellow", IF(OR(TODAY-[INVOICE DUE…
-
Color parent row while any children rows becomes red
How may we construct a formula so that a parent row will be highlighted in red, if any of its children row becomes highlighted in red color? Thank you. Jon
-
Auto-Number starting with 0
Hi I spologize in advance if I've already asked about this (it has been rattling around in my head for a little while but I can't find that I already posted this question on here). It doesn't appear that you can begin AutoNumbering with 0. Whenever I try it, it just defaults to 1. Am I doing something wrong? I would like…
-
Dynamic Dates
I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due within the next week). I…
-
Trouble with Downloads
When I click on an attachment, the file starts to download, but the process doesn't seem to make progress and the download never completes. Thsi has been happeneing for about 4 days now. Any ideas?
-
Android App - Shared sheets cannot be opened... "network error"
Has anyone else come across an issue where some (not all) of shared sheets cannot be opened using the latest andoid app? When trying to open a sheet, a "network error" appears. I've performed the same test on an iOS device, and it works fine.
-
Auto-generated Create Date - remove time
I'd like to filter on things created on a certain date, I don't need time. Anyway to remove time from the auto-generated field?
