-
Smartsheet merge for google doc
Hi all, One of my departments is using merge for google doc this works fine. But I wanted to try to merge a report but this is not possible. I think it is nessesary to present a report in a more document form. Ofcourse it is possible to do it from the original sheet but you need to scroll allot if you have 100 rows.
-
How can I see a dashboard of all my projects - from Home Page?
Is there dashboard view for all my projects? Something that launches as Home Page?
-
Parent/Child relationships
I have a master document for my product codes. Several products have multiple parts that come together to make a whole product. On my master I have parent/child or indent relationships built. However when I run reports off the master the parent/child relationship doesn't carry over. Is there a way to make it carry over?…
-
Question about creating a pricing sheet with multiple linked sheets
Hello, New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep…
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
Transpose Webform Results
We are collecting quantity and item descriptions via webform for internal supply requests. Each row is a request. The first several columns in the row are the requester's information (Name, Dept., etc.). All other columns in the row are corresponding quantity and item description "pairs", such as, "Stapler Qty", "Stapler…
-
Formula to count project status
I have a formula that is counting the different status of projects. This is what I have so far but the counts are not accurate. This might be because there are children however the total count is correct. Any ideas to what is missing? ="Status Count: " + COUNT(Status:Status) + " In Progress.................. " +…
-
Copy date field into text/number field
I have a summary at the top of my project plan that has, as a part of it, phase 1, phase 2 and phase 3 go-livedates. I would like those dates to update automatically when the start date of the go-live changes. I've tried a simple =cellname1 but I get a #numberexpected error. Do I need to convert it into something first?
-
New Web Form rows being added to the middle of the sheet.
Hello guys, My subject really says it all. I have a Smartsheet, for which I have created a basic Web Form. Unfortunately, every new row added via the Web Form is deposited into row 63, whereas the sheet currently populated to 21 rows down. I used to have an 'auto-number' column, which I removed as per instructions (i.e.…
-
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
