-
I would like to hire an experienced consultant
I am relatively new to Smartsheet. I need someone to help setup Smartsheet to manage our book production schedule. We publish books (print and e-) and have managed our production schedule for many years with a Google Sheet. It is severely lacking. I have not yet signed up for any plan. I don't think I'll need 3 licensed…
-
Projects per sheet?
I have 10-12 projects each year that will use the same project steps. Is it better to create one sheet to house all 10-12 projects and seperate them using the parent/child relationship. OR, is it better to create one sheet per project? I'm also thinking about how this will report up to a Smartsheet Sight for status updates.
-
Managing Resources by duration and not % allocation
Is there a way to manage resources by time rather than having to use % allocation please? Any way aound this? Its actually not that easy to manage using a %. Sad that smartsheet didn't think it would be an important feature. I'm no software expert, but seems like not too difficult a fix if they already implemented it for…
-
Hiding Rows, Columns from Client or User Access
Hello. I've searched and thought but I want to ask the question anyway: Is there some way I haven't found, to hide a row or group of rows (or only show the ones you want) from a user or published view and keep those sent rows in an interactive environment? Heres the situation: Out of my 200 row sheet, I only want to show…
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
Use more row content as the default text of the subject field when sending a quick update.
We would have a huge increase in productivity if we could use more than just the primary column row content as the default text of the subject field when sending a quick update.
-
Allowing for unresourced time requirements
I'm evaluating using SmartSheet for project managing construction projects. So far, so good. One of the requirements is to allocate time for processes such as plaster drying out. So no resource is required, just a number of calendar days, which can include weekends/holidays. I can set up a "task" for this with dependency…
-
Update request format - change to table view?
My team is new to Smartsheet. It would be great if I could send update requests that show up as a table view, rather than form view, so that the view is consistent for these new users. Is this possible? If not, can this function be added? Right now I'm using the workaround of publishing the sheet, selecting the rows to be…
-
GE GAL
I’m trying to figure out if there is a way to have the entire GAL (GE Outlook user database) accessible via the smartsheet, or by a user interacting with the request for update via a webform (or email entry). I have a user base that needs to log its interactions with other GE users so we can track activity for the team.…
-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…
