-
Sharepoint site refused to connect in work apps
Hello , this embed SharePoint page stop working last week. I don't have any issue accessing the SharePoint original page. I guess this issue is related to Smartsheet workapps application. Does anyone know what it could be?
-
Repeating Data
I have a sheet that pulls information from a master sheet to keep track of dates. 3 columns are repeating data and have been for a few days now. Is there a problem with the formula? I have seen this happen before, but signing out and back in a day later, it usually fixes itself. This time, it has just shown the same value…
-
How do I get the Credly badge to display on my profile?
I got Core Product Certified about a month ago at ENGAGE. However, I did not receive an email with a Credly badge like I did for the Core App self paced learning. I also haven't received the badge here on Smartsheet Community. I'm not sure if this is an issue because I took the certification exam in person, but I'd love to…
-
NEED IMMEDIATE HELP ON A DASHBOARD ISSUE!
Can someone please help me overcome this strange issue in Smartsheet dashboards? I can't show it to my clients! The dashboards should be intelligent enough to display a clean arrangement! Further, we can't even reduce the point-size of these numbers... above each bar. PLEASE RESOLVE IT AS I MIGHT LOSE BUSINESS DUE TO THIS…
-
Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
-
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.…
