-
Converting UTC timestamp to Hawaii Standard Time timestamp
I've been importing data from Toggl (toggl.com) using Zapier (zapier.com) to SmartSheet. The date/times are recorded in Toggl in UTC, and I'm trying to convert this to HST (i.e. -10 hrs). My settings are for HST. The UTC format: 2019-03-15T02:43:21+00:00 I've tried several suggestions in other posts/solutions for…
-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Global Updates and using VLookup formula in it.
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not successful in accomplishing that. Please some suggestions.
-
Columns Filters on Phone/tablets
Hello dear Smartsheet community. It appears to me that it is only possible to apply "Preset Filters" on smartphone/tablet Smartsheet App. Those named filters presets created on the "browser" version. Using the Android application I can only find the "sorting" option for individual columns, no column "filtering". Only…
-
Difficulty Printing
Im a little miffed at the amount of discussion on this topic, dating back years... and Smartsheet has not fixed the problem. I am not a Tech guy, but whatever the reason is, just make it easier!!! Its way too complicated to print a sheet onto one sheet of paper and keep it scaled right. is there not some programming…
-
Hyperlink in email notification that redirects to the relevant row
Hi there, On receiving email notification, there is a hyperlink to navigate to the sheet. In this case, user has to find the row in the relevant sheet among hundred other rows. Is there a way, where a hyperlink can directly navigate to the affected row rather than the sheet. So in case of multiple rows in email…
-
Auto Sort Based on radio buttons
Hi is it possible to move rows and children within the rows to a different sub-category. e.g. we have a purchasing smartsheet which has 3 status icons which are either blank or green for processed for: 1. Ordered 2. Paid 3. Delivered Based on the status of each column i would like to sort the sheet into three categories,…
-
Default sorting of attachments
Good afternoon, Is there a way to set the default sort for attachments? Currently it is by date and we'd like the default to be by name. Blessings, Loann
-
Switching a subtask to a main task?
Is there a way to switch a subtask to a main task? Projects have the same annual processes that need to be tracked but i want to display the current year as the main task and drop the previous year to a subtask. Is there any way to do that? And, is there any way to automate that? Thank you in advance!
-
Conditional formatting based on location in hierachy
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters. level() would give "0" if top level and "1","2" ... depending on the number of indentations. has_children() retruns true or false. Combined this would allow: - making filtered reports only extracting…