-
Setting Non-Working Days based on Assigned to name
Hello, I have a rather odd question that I'm not sure if anyone else has dealt with. We have a project with team members located at different facilities around the globe. As a result, we have different holidays associated with the various regions (EU, USA, Asia Pacific, etc) that will impact the working days available for…
-
Separating weekdays from weekends
Hi everyone, this is probably something very simple, but I still struggle, hope you can help. I have a large timesheet with one raw per day, every day of the year. The contractors will get paid higher rates on weekends, compared to work days. Initially I thought of putting an extra checkbox "weekend" column next to the…
-
External clients access to view worksheets
I have created a project program which our client was able to view, however she now needs a"Log-on" & Password to be able to view my sheet. I haven't changed any settings, so I need help to let her view the project program?
-
Modify a Smartsheet I didn't create
I'm having trouble and I'm not able to find the answer using the search community. I'm helping another licensed user to modify their Smartsheet for use. That requires me to add columns, rows, equations, etc. First step was the other user made me editor. I was able to add/delete/modify rows and cell equations but I was not…
-
Forms - Cap entries
Hello, I am attempting to use forms to create a registration list. The problem is that the registration has a cap. My question is can I setup a form to send a message or not allow someone to use it after the cap has been reached?
-
Card View in Reports
Is it possible to have Card View in reports? It would be great to be able to see a card view board for multiple sheets at once.
-
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…
-
Can I Get a 12-Month Calendar View?
I mapped out key dates (for a full year) for the organization for which I work. I know how to get the Gantt chart view, but we want a Calendar view that displays all 12 months at once. Does anyone know of a way to display 12 months at a time, instead of only 1-4 weeks?
-
#DIVIDE BY ZERO” error
I have a formula in Smartsheet that calculates Accuracy by using the following formula: Estimated amount-actual amount/actual amount. Until the “actual amount” is filled in (sometimes weeks or months later) the formula returns a “#DIVIDE BY ZERO” error. The error is fine as far as the calculations go on my pivot tables.…
-
Why does a Project Resource View show other projects?
Smartsheet has Project Resource View and Cross-Project View. One would assume that the prior shows resources for a single project and the latter shows resources across multiple projects. However, within a single project plan, when you click on the Project Resource View icon, it brings up a report that pulls in information…