-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Authorisation workflow
Hi, I am in the free trial period with SmartSheet and I am trying to work out if I can make it do what my organisation needs. I want to create a workflow to enable my colleagues to create and authorise projects. At the moment we are using word documents and emails. I have a few questions: · I was hoping to move away from…
-
Newbie please help - is this possible
Hi there I'm new to smartsheet and I'm wondering if the following is possible... I'd like to have a template waiting in smartsheet. I'd like to setup a Google form, when its populated, it would automatically be forwarded to smartsheet, as it arrives a new sheet is created based on the Template I created previously. I would…
-
Building Asset Manager Template
Hello Community Would anyone have developed a Building Asset Management Template from the one in Templates. Inparticular regarding ongoing maitenance and periodic safety inspections? If not, I would be pleased to share when I develope one. Thanks in anticipation
-
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
-
Volunteer Management
My organization has a large event in which we use 250~300 volunteers in the lead up to and day of and we've been underwhelmed with volunteer management tools on the market. We've managed much of our volunteer management over the years via Excel which implies smartsheet is a viable solution that allows us to manage the…
-
Removing Answer Choices from Webform
I am making webform for event sponsorships. I would like the sponsors to select which events they want to sponsor - but each event can only have one sponsor. Is there a way to have a dropdown menu that eliminates choices once someone else has selected them? For instance, if I have sponsor event A, event b and event c, then…
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
More column types?
Any chance we will see additional column formatting to include things like Currency and Phone number formatting?
