-
how to see the collaborators ?
I don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest? See images please. Thanks
-
SFDC Connector - Snapshot Then Track
I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My challenge is that I'm developing a project management process that relies on seeing the…
-
Saving Sheet changes
Hi everyone, someone on my team brought this to my attention and i want to see if anyone else has experienced this. I have a sheet where the 90% of the data is entered via a form. the remaining 10% of data is filled in afterwards once some additional information is received. my team member says that he is 1000% certain he…
-
Average Days
I am looking to have some metrics set up on a dashboard all around average days to close. I have a column for a sales person, two date columns (one a start date and one a close date) and a column called Workflow Status. How can I do the two following things via formulas: * Filter this first by the workflow status being…
-
Updating an aggregation sheet/dashboard with weekly data
Hi all, I'm struggling to think of a way to aggregate data that changes weekly. I will try and describe as best as I can! We have a sheet that financial advisers fill in weekly (separate sheet for each adviser) to show various information as attached in the screenshot. The adviser updates this weekly every Friday, and adds…
-
Data Import in bulk from Excel
Hi, Can anyone suggest how to import the data in bulk from excel, the number of data is around 37000. I can see that we have limit upto 5000, On Smartsheet I have to weekly import the data for the production. Copy and pasting is also not working as we have limit of 500 data at a time.
-
FILTER A REPORT ON MOBILE APPLICATION
Hi, I am interrested to know if we can filter on report on mobile apps. I explain, on computer we have the possibility to choose filters by Where, Who, What, and/or. It is really helpful to have an activity follow up linked to many sheets. On mobile, for the same report, I don't find the way to do it. Do I miss something…
-
Totaling percentages linked from another sheet
I am simply trying to get an average percentage in a parent row from children rows that are linked in from another sheet. Is the fact they are linked what is causing my error? Currently I'm just using: =AVG(CHILDREN())
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Automate a rent increase on certain date
I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount. I can use the Index and Match to pull in the amount, just needing…
