-
Enable Edit Format For Symbol Font Size
Hi, Team. I've seen several topics about users wanting to be able to change the symbol font size as they are still a tool limitation since 2018, so as mine for a project that I am working on right now, where I would like to have my symbol bigger, and it's 2023!. I am looking forward that this idea this will be considered…
-
Which formula do I need "Has" or "Countifs"
I'm having trouble knowing what type of formula to use in my dashboard, and how to get the results that I need. To preface - I am very new to Smartsheet, and the use of formulas so pretty much "learning as I go". What I have here is a result of combined YouTube videos and LinkedIn learning Smartsheet 101 videos. Let me…
-
Hello, i need some help how do i connect the %complete column to the status column
for example if the status says in progress i want the %complete column to automatically say 50% can anyone help me?
-
Merged: Additional Form Settings
This discussion has been merged.
-
Is there a better way???
=IF($[Year Select]$2 = "2023", [2023]@row, "" + IF($[Year Select]$2 = "2022", [2022]@row, "")) I am having an issue where I can select 2023 just fine, but when I select 2022 all of my reference dates change to a "Text date" and the formula in the data 1 & 2 columns do not recognize it. Is there an easy way to fix this? 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…
-
Why are Non-Working Days set in Admin Center not feeding into new sheets?
Hi, New sheets generated via the save a copy method are not picking up the global non-working day dates set in the Admin center - are they considered to be generated from a template and therefore do not pick up the global settings?
-
IF Function to Add Quarter and Year
Hello, I am editing a smartsheet that tracks tasks. I have a column for the quarter that needs the year based off [End Date]@row for all tasks added after the calculated quarter. I am using the formula: =IF(ISDATE([End Date]1), IF(MONTH([End Date]1) <= 3, "Q1", IF(MONTH([End Date]1) <= 6, "Q2", IF(MONTH([End Date]1) <= 9,…
-
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.
-
Can we pull the capacity % information from RM to Smartsheet?
Hi, I am wondering if there is a way to pull the capacity % for the disciplines and roles that's already provided in the Capacity window (under the schedule tab in RM - snippet below) back to Smartsheet? The reason is that we are in the process of having 3 different RM workspaces for 3 different entities, however, the top…