-
Filter rows under parent row?
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue is submitted via the form for a High Priority. Have it automatically sort under the High Priority Parent Row? As of right…
-
Total Age tracker overwrites last modified
Hi all, Hoping someone out there can help and hoping its just something simple i need to change. We use Smart sheets to monitor cases by age outstanding to help prioritise what needs looking at first. so i have a formula to grab data from a cell says A1 that has the TODAY function in. and then take that away from the last…
-
Why is Embed Restricted to Certain Domains
Why can I not embed whatever I want into a Smartsheet dashboard? I want to embed a timer, but it won't work because it is not on the list of approved domains... I don't understand why it is restricted at all. I was attempting to embed the following code: <iframe width="250" height="125"…
-
Searching from one sheet's range & search/match to another sheet's range for a unique identifier?
Hello, Is it possible to search from a range in one sheet and search/match it in a different range/another sheet? This has plagued me all day and therefore I can no longer remain clear headed about what the best course of action should be. I have two trackers in completely different departments; QC and PROD. I want to…
-
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…
