Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
If and checkbox
I have used th IF equation and the checkbox and I want it to copy a value from another cell when the checkbox is checked. Until here I am ok. However I want it to apply the number "0" (zero) when the check box is unchecked. can anybody help me please? Thank you.
interconnecting several sheets (to manage employee action items)
Is it possible to share 2 or more interconnected sheets such that there is a parent sheet and multiple child sheets and the parent rolls up the info on the child sheets, allowing any changes on either the parent or child shows up for the other users? The key is that this needs to be bi-directional like normal smartsheet…
% complete value not adjusting start date of next task
Hello I am hoping someone can help please, here is my problem I have a few tasks, dependent on each other - D is dependent on C, C is dependent on B, B is dependent on A etc etc. I have a complete tick box for them and also a % complete column Task A is complete, Task B is 40% complete, Task C is still showing it starting…
Display report data rolled Up?
Hi there I’m currently running an exercise where we are asking a group of 30 users 10 sets of questions each. Each set of questions has its own web form so there should be 10 responses from each user (300 separate rows in total). I have this working fine. The users have requested a ‘dashboard’ which would allow them to see…
Allocation for Project Manager
We are using Smartsheet with Resource Management enabled. We are tracking % allocation for employees and would like to do so for Leads as well. The idea is that the Lead would be allocated for the duration of task consisting of smaller subtasks at, say, 20%. We are using the Basic Project with Resource Management template.…
Send Update Requests based on a Contact column
Is there a way to send an Update Request based on a Contact List column? I have a large group of people and I need them to update their personal contact information. Rather than filling it out new every year, I would like them to receive it in a format where they can simply hit submit if none of the information has…
Using Smartsheet report to populate website data
We are developing a new website for our company and want to incoporate some sort of link between some of the data we have on SS and displaying it on the website. Is there a way to do this? What is the best platform/back-end of a website to talk to Smartsheet? I've had a look around the SS website and cant really find…
Calendar sync
Can I sync the calendar with my Google calendar so only tasks related to myself show up?
Is there a way to tie a web form to a specific record?
I have a SmartSheet where the user enters the preliminary information via a webform, which assignes an autonumber to that record. I would like them to be able to update that record via a webform without me having to send an update request. Is there any way to create a webform where the user enters the item number and it…
Row limitation?
Is there a limit as to how many rows I can have in each sheet?
