-
Formula Error
I am trying to Sum up the parent rows and am getting an "Unparseable" from my formula. Here's the formula. Please let me know what I am doing wrong. I have tried 1 to 4 closing parentheses as well. Same thing. =SUM(PARENTS([ST Rev ($)]5:[ST Rev ($)]65)
-
Smartsheet Merge Add-on how to change the folder name
Hi, Smartsheet Merge Add-on is a great tool for generating Google Docs based on smartsheet data. The generated files are save in a folder and I would like to change the folder name. I could not find any configuration possibility, does anybody know how make this? Thank you and best wishes
-
Tracking time in forms
Good afternoon, We are creating a form/sheet to track our deliveries to job sites. We want our driver to be able to log the time he arrives on site and the time he leaves. Is there a time feature we can use for forms? Thanks
-
Adjusting trip start/end date based on certain members holidays
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteerĀ for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our membersĀ are college students with varying schedules and holidays planned. (I already haveā¦
-
Sharing Sheets Automatically
Hi, Could we share sheets with new contacts automatically? I have a form and in this form I need to add a new contact, by adding his email. So a new contact is created in smartsheet automatically, but I need once this contact is added or when the form is submitted I need to share the sheet with him automatically, withoutā¦
-
Filter on Names stopped working
I have a number of existing filters created from a 'Contact List' column and these work fine. I'm now trying to create some more and they don't work. The Filter is simple enough, just based on a name (email address) and even if I copy a filter and pick a different name the filter doesn'tĀ work. Any ideas please? Thank you.
-
Client dashboards
Hi, I'm currently using airtable but thinking of moving to smartsheet. My specific need is to take the table data (which my team updates 24/7), format it into simple dashboards, and provide those dashboards to clients particularly via mobile device. With airtable I can display data via mobile devices but not in a dashboardā¦
-
errors
hello i am trying to use the COUNTIF function, where the range & criterion are the results of a VLOOKUP from another sheet. When the VLOOKUP doesn't find what it is looking for, it returns a #NO MATCH Error and this in turn gives a #NO MATCH error in my COUNTIF. On the VLOOKUP it is looking up an activity against a rangeā¦
-
Date Range Printing
Hi, I am having trouble printing a specific date range in gantt view. I've selected the dates, tried printing, but it shows the full spread and never reduces to the specified date range. HELP! Thanks, Simon
-
Formula involving multiple IF/AND statements
I need to modify the following formula to include additional AND conditions. =IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red")))) The additional condition would be in the third if and would beā¦
