-
How to recreate a payment month Excel formula in Smartsheet
Hoping you might be able to help me with migrating a formula from Excel into Smartsheet. I'm in the process of recreating a payment tracker solution for some colleagues of mine, but I'm struggling to replicate one of the formulas. The formula is as follows: =IF(DAY(C4)<=3,TEXT(C4,"yy-mm(mmm)"),TEXT(C4+30,"yy-mm(mmm)")) The…
-
Work App Page Permissions are locked
We are using control center to auto provision a project folder in a workspace and a work app for the project. The auto provisioning of the work app creates several roles, defaults users to those roles and adds pages with page permissions for each role. As the Work App Owner, I am trying to change the page permissions for…
-
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…
