-
Row order
when you log in to smartsheet from cell phone, the oldest info in at the top. you have to scroll through all these rows to get to the most current entries. Is there a way to set these sheets up, kind of like an e-mail in box, where the newest info is at the top?
-
Formula to create hyper link with display text defined
I want to be able to clean up/simplify how a link is displayed in a cell. Column A: the text I'd like to use for the link display Column B: the long URL with lots of URL tokens, folder locations, etc.. Column C: a clean, short, hyperlink made from A&B Example values A: Profile B:…
-
MsProject import to template
I need to import a Project from MsProject, but I will like to import it to an existing template. But every time I try to import it from the template it will open a new sheet with the Ms Project info . Is there any way to import the MsProject directly to an existing template ?
-
Auto pre-populate a web form
Good day, I would like to pre-populate a smartsheet form with values in certain columns. I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text. However, I want to avoid having to create each URL by hand, this will take forever. Is there a way to automatically generate the…
-
Gannt Chart - multiple milestones on the same row
I want to set up a recurring set of weekly meetings over a 3 year project on a single row. So far the only way I see to do this is to have a separate row for each meeting....painful. I can do a roll-up, but it graphically shows as a continous bar. Preference would be a series of diamonds (milestones). Any ideas? Much…
-
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights. What I need to do…
-
Interactive Forms
I would like to create a form to collect a variety of information from users. For example, we want to record publications, presentations, and proposals that a faculty member has done in the past month. However, I'd like to keep the form short. If a faculty member has had 2 publications, but 0 presentations and 0 proposals,…
-
SysAdmin
Good Afternoon, We use Smartsheets rather extensively. Our SysAdmin has since left our company and I need to assign a new SysAdmin to our account. How do I go about doing this? Thanks
-
Sending notifications to a contact list; user not shared to sheet
Hello! I have a sheet where there is a "Contact List" column and I want to send a notifications to that contact, but they are not shared to the sheet. The contacts are not receiving the notifications currently and I'm not sure why. I thought this was an upgrade Smartsheet made recently, but maybe I'm wrong. Thoughts?
-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
