-
Much more Community related events (Booth maybe) at Engage
I really enjoyed Engage and I was looking forward to the talk about the community since I find it so useful and great. It was disapointing that in the 2 days of Engage, only 5-10 min were allocated to the community and there was no Booth about it either. it is such a valuble resource that I think it should be highlighted…
-
Community improvement - get alerts on conversations you participate in
This idea is actually for the community rather than the Smartsheet program; right now when you answer a question and the original poster replies to you, you only get an alert if they @ your name. Consequently, a lot of follow-up questions go unanswered. If we could add some kind of alert for "A new post was made in a…
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
Remove Primary Column From Report
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
Login Issue!
Hello, My team members are unable to log in to the workspace they're encountering an error message that says 'Oops, something went wrong' have attached the Screen shot for your reference.
-
How to use IF
This might be simple, but I am a beginner. Team members will be pasting one of these 10 cities/counties into the Area column and selecting either “Experimental” or “Written” in the LOB column. I want their choices to automatically populate words into the District Column. Some have a 1 to 1 relationship, others have a 1 to…
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
NETWORKDAY error using cross-sheet reference
I would appreciate help figuring out this error please. I'm trying to determine the number of working days from the start of the project to when it went live (Hypercare). The calculation is in the Metadata and references the Enable Service date field in the project plan. It returns #UNPARSABLE error. # days to Hypercare is…
-
How do I prevent a category from showing up multiple times in a Pie/Donut Chart?
I made a pie chart from one of my sheets. I wanted to show how much was spent based on each category. However, in the widget it shows two of the same category in different slices. I'll include an example. Why is eLearning showing up as two separate parts instead of combined? Its the same category.
-
SUMIF(S), AND, IF, Checkbox formula functions
Hi brainstrust, I am trying to build a resource conflict formula(s) that deliver the end results of: If a project row has overlapping dates AND has the same resource type(s) selected (different columns with check boxes) as the date-conflict project rows, return a "conflict" result. AND If a project has a resource type(s)…