-
Limit to Shares for Admin and Editors w/o Subscription
Hi Smartsheet Community, I do not have a paid subscription but was set up as an Admin for a sheet. I had only shared it with 2 people before it sent me a message that I had exceeded the number of email recipients that I could share with. Is this accurate? Do "editors" with sharing privileges have more shares that admin?…
-
Functionality Question
Hello, I am more of an Excel guy who is attempting to wrap my head around Smartsheet. I have a scenario and I am thinking it can be done, it seems like I almost find the answer but just not quite. I have records which require attention, usually in contacting users and getting require, late training complete. There are a…
-
Sheet Summary Report Grand total row ?
I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet. e.g. Miami $138,875 Tampa $264 My question is…
-
Hide email addresses when sharing page
Hello, we have a dashboard that we want share among different groups but in our testing, we saw that the email notification notes the various emails that are included. Is there a way to hide these email aliases? Since these are different groups, we don't want their emails to be shared among each other.
-
Combining AND & OR in a formula
I have a sheet with the following three columns: --Was the question asked --Answer 1 y/n --Answer 2 y/n I want the formula to turn the flag red (cell already formatted for flags) if the question was asked, and either answer 1 or answer 2 were no (aka, i need all the no's from everyone who was asked the question). So far I…
-
Missing columns on XML export of Gantt chart
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is missing. Really need this to work to tie into a portfolio management tool the company is…
-
Need help with creating aging buckets.
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",">30",">45",">90",">180"}) I am entering this formula in the column "Equipment Date Range" and validating the data on column "Days…
-
How many rows can a report collect?
I created a report that pulls data from 4 different sheets. It has multiple items on a single date, so calendar view is the only view I am interested in using. The data on the sheets goes up to May, but in the report, it stops showing at April 15. When I look at the report in Grid mode, it is exactly 500 rows. How can I…
-
Use a form to trigger a new project
I'm trying to automate the onboarding process for new hires. Here's what I want to accomplish: We hire a new employee, the manager fills out a Smartsheet form and based on that form it starts an Onboarding Project sheet that is a template. Can I do that? If so, how?
-
How do I track incoming emails in a Smartsheet?
We are getting slammed with inquiries to our info@ gmail address. I think there's a way to send all those emails to a Smartsheet so I can assign, triage, and track our responses.
