-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Listing more than one "assigned to"
We have a project sheet and my boss often assigneds a task to more than one individual. However he does not want multiple lines that are duplicates "just to assign the same item to multiple people", He does want to be able to send reminders. What to do? I've thought of creating an email group - giving it a name and using…
-
Notifications not including attachments
We've set up a new webform that requires an attachment to be included. The attachment gets uploaded and shows on the Smartsheet but the email notification that is received doesn't have that attachment. I've doublechecked the notification settings and it does show that the attachment should be included in the notification.…
-
Uniform Inventory
Does anyone have a use case where they track uniform requests? We have a 8-10 types of uniforms that vary in sizes. I need to track (via form) what people want, and have it pull from our inventory. I'm just not sure the best way to set up my sheet. Any ideas are welcomed!
-
Can your event span time in calendar view?
I am using Smartsheet’s Product Release Roadmap form. I added a start date and an end date to the cards so that the projects can span a period of time in the gant view. Is there a way I can make it so they also show as spanning a period of time in the calendar view? Currently, each individual card is only showing as the…
-
Avg formula % complete based on a specific end date
Hello, I would like to know if it is possible to create a formula that calculate the average % complete for all tasks that are ending at a specific date (important milestone) in my schedule. The schedule I have have a lot of tasks going all the way to 2020 but I want to track only those that must be completed by Nov 2018.…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
-
Need help to upload new data from Excel to existing sheet
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can use the new data to refresh/update a dashboard connected to that existing sheet?
-
Cell linking report sheet linking
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new workspace or folder for each project. I am hoping there is a way to make the project/sheet links stay within the…
