-
"Master" or "Global" Sheet
I am new to Smartsheet and am using the 30 day version to determine if this app will do what I need. Two questions I have is in RE: to the Sheet. I run a PMO and have 12 PMs. 1.) Can I create a Master or Global Sheet and lock it down so the PMs use that sheet I have created which has specific Milestones, Q-Gates and Phases…
-
Love the "Freeze" pane option!
We just started using this option, as we have 71 columns in a particular sheet and scrolling back and forth was becoming quite cumbersome and inefficient. We put our three most important columns at the front of the sheet and the the freeze pane in place at the end of the third column. So far it's been noted as a very good…
-
Web forms and formulas
Good afternoon, I have a simple sheet for a balance sheet, and I'm needing to know if there's a way for the web form submission to be included in the formula in my sheet. The last row & column of the sheet houses the formula from previous lines, but when the web form submission is added, it goes to a new row, not the last…
-
Formula help - if cell is blank, checkmark cannot be checked
Brain cells are missing. I've looked through the formula examples and can't seem to put together the formula I need. We have a column that needs to have text in it before the Checkmark column should be marked with a check. Here's the scenario: IF column B is empty, checkbox cannot be checked. This will help our team…
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
How do I add google docs functionality to smartsheet ?
It does not appear in my drop down menu nor am I able to add it under the App tab in settings. Many Thanks
-
Adding current location to Web Form from mobile device
Hi Everybody! Health care providers are using WebForms to submit invoices from mobile units (RVs). Since the location of the RVs change (and we're in NY so addresses = intersections <> map-friendly), is there any way to add location from the mobile device being used to submit the Web Form? Apologies in advance if this…
-
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…
-
Text/Number column is editing my number
I input the number 2800.06610 and Smartsheet edits my number to 2800.0661 which means it is eliminating the zero. This column does not have any conditional formating. What am I doing wrong?
