-
Vacation Days Formula - calculating half days
Hi, I am trying to incorporate 0.5 days of annual leave into my vacation tracker. I have the forumla =NETWORKDAYS([Start Date]@row, [End Date]@row, {Bank Holiday Lookp}) to calculate overall number of days out (minus public holidays). From this total I then want to include any 0.5 days from this when 'half day requested'…
-
My dashboard users are unable to view some of the charts, however I am able to view them correctly.
My users of the dashboard are getting the below error for some of the charts, however I am able to see them correctly. Please advise what is the solve for this error.
-
Support - Formula that calculates difference between times in a quarterly increments
Hi Smartsheet Community, I'm attempting to figure out a simple formula that would calculate the difference between 0800 and 0830 in quarterly increments. At this current time i'm unable to figure out how to create a successful formula that would show the correct -0.50 for the following. Should 0825 and 0900 be entered, the…
-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
Trouble reaching a human
Hey all, I made a mistake in registering for some training at SmartSheet University. It has been like 2 weeks of trying to contact a human to resolve my issue. I have opened tickets, left messages, sent emails, .... and not 1 person has reached out to me. Do any of you have any suggestions trying to contact someone? I…
-
Unexpected movement of rows - older post recommendations not working
I read an older post from someone else on this issue, but despite our best efforts, rows jumble unexpectedly and its such a significant problem we might not be able to continue with smartsheets. Here's what happens - we have a shared sheet showing our project schedule. Each project has a line and there are dependencies set…
-
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
-
I am identifying the duplicates in the sheet. What wrong with this query?
=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1), 1)
-
Are you able to hide specific rows from people on a shared sheet?
Hi, I am working on building a sheet for our CEO to track employees tasks and deliverables. However, he wants 1 sheet with multiple viewers (the team) and to be able to make the sheet so that each team member can only see the tasks (rows) they are assigned to and not be able to see any rows that are assigned to other team…
-
COUNTA alternative in Smartsheet
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
