-
Trying to create a formula that determines the current season
I've got a formula that generates the current quarter and one that calculates the current year. Now I'm trying to write an IF statement that creates a value that says S23 by reading if its Q1 or Q2 and then adding the 23 from the current year (2023). This is my current formula, can anyone explain why it's not working or…
-
Automation of responses from one form onto a second form?
I'm developing a skills competency checklist using 2 forms to collect info (1) self-assessment for staff to check-off skills and (2) Validation/Assessment from preceptor to check and sign-off that skills were validated. Is there a way to set up logic that auto populates responses from the first form onto the second form so…
-
SUMIFS with 9 criteria
I am trying to sum specific values based on a dropdown list in one column and display that sum in another column. I have an "Amount" column , a "Total Final OEP 0708 Cost Center Spent" column , and a "Cost Center" dropdown column. I want to sum CHILD rows in column "Amount" based on the drop down option that is selected.…
-
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…
