-
Syncing/Keeping Files Current from Dropbox
Does anyone know if files will continuously sync from Dropbox? I've followed the directions to attach files to a workspace from Dropbox, but any changes I've made to those files IN Dropbox are not syncing to Smartsheet. The article about "Keeping Files Updated" doesn't specify. It IMPLIES syncing, but doesn't explicitly…
-
How to reference cell based on MAX date and another condition?
Hello! I am trying to reference another sheet that has multiple data for the same building: On another sheet I am trying to pass over the information from Column4 if Column3 equals "Cobb Stadium" and by picked the MAX Created Date & Time. So it would pass "Yes" Since the last row has the Max date and time from today.…
-
Contents of a Dropdown Multi Select Column
Hi All I need help in using the contents of a Dropdown Multi Select Column. The column has the following options A B C I want to use the actual content say AB to lookup another Smartsheet for a price for that selection. I am sorry if there is an obvious answer as I can’t find it. Thanks AV
-
Workflow to move rows with cross sheet references
I understand that if I create a workflow to move rows with cross sheet references into a new sheet, that the cells with my formulas will not maintain the reference. Is there a way to move those rows and have them retain the values only from that initial reference?
-
Can I create a SUMIF "does not contain" with multiple values?
Trying to add up the number of people from all cities but, CityA, CityD, CityF, etc in the same argument. Is there a simple SUMIF formula i could use? Currently I have been using: =SUMIF([City]1:[City]51, <>"NYC", [# People]1:[# People]51) but i want Smartsheet to exclude multiple cities. I've tried a few options but felt…
-
Nested If Formula (Multiple Conditions)
Hello, Hoping to get some help for a rather complex nested if formula I'd like to build based on responses to a webform. Below are the conditions. Is this possible to create an if formula around these conditions to result in a a red/yellow/green visual symbol? Any help or guidance is much appreciated! Thanks so much!
-
Formula that checks if a certain date is in a date range and TRUE/FALSE VALUES
Hello! I need help on a formula that outputs a count and a sum since we are unable to build formulas from a gantt chart. This is the formula page I am using in order to build a gantt chart with a bar chart in a dashboard with month counts and sums. I created this report to show what is needed in the formula. Count: Count…
-
Open Sheet in Gantt View
My sheet is opening in grid view. I can change it to Gantt once I am in the sheet but how do I change the settings so that it just automatically opens in Gantt view?
-
Image Header Size for Dashboard
I'm trying to include a header image for each of my client's dashboards. I had my content person create an image that spanned across my browser, that was saved as a png file. However, when I add it to the dashboard through the Image widget, it barely spans half the page, and I can't make it bigger. I want to be able to…
-
Different formula for a cell basing on condition
Hi All, How can i apply different formula basing on cell value? For instance i have a columns Type, Duration, Original If type = "Sub-Task" I need formula for Original "= Duration*1440" If type = "Story " I need formula for Original "=SUM(CHILDREN())" i tried IF(Type = "Sub-Task" , "=Duration*1440", "=SUM(CHILDREN())") but…