-
Inbounds to Smartsheets from external sources
I know there are a few connectors for outbound (ODBC) data to all kinds of places but has anybody gone the reverse, i.e. inbound from, say excel, to a sheet. I get the reason to export into tools but I'd think there would be enough cases for being able to pull in data from other places. Anybody?
-
Overlay Google Calendar in SS in a grid
Im going to implement a time management report in the company to understand how the staff spend their time (meetings, planning, execution, travel, etc) To do this we use a name code in Google Calendar that enable us to automate the analysis, like this. * All meeting start with MEETING... * Task-related to projects starts…
-
#Unparseable error after saving from android app
For some reason my formulas are suddenly showing #Unparseable after the sheet was updated on the mobile app. Not sure what is wrong, can anyone take a look? https://app.smartsheet.com/b/publish?EQBCT=5682096f4bf44ebda10e855be7e57aa6 Ty M
-
Formula Help Needed
I need a status formula for the parent row of up to 5 children rows. The children rows have a control rating of 1-3 If rows 1-5 have a control rating of 1, the status column should reflect "Closed" in the parent row. If rows 1-5 is 2 or 3 then parent row should show "Work In Progress" If ALL are blank then status should be…
-
How to use Formulas to change the value of Symbols and Check Boxes?
I'm kinda new to this. I'm a little familiar with how formulas worked in Microsoft Excel, but not a pro in the slightest. I only know basic stuff. How do you use a formula to change the value of symbols and check boxes and drop down menus? Also, I've been having trouble pulling the data from dates. I always get the…
-
A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a…
-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…
-
Using Parent / Children functions to roll up dates
trying to add new columns to show some milestones end dates on the parent row. For example, if i have a summary parent row called "Project 1" and one of the child tasks called "SOW", i want to show the SOW date rolled up to the summary row in a new custom date column using formulas. Any idea how to do that? Not so sure how…
-
Insert Time Stamp
Is there a way to insert a timestamp into smartsheet when a specific field has updated? I would create a column that it can be stored in I just don't want to have to have the team manually update it. I need to be able to see what was completed yesterday. thanks
