-
Template that automatically sends notifications to assignees on due dates
I'm trying to find an app that automates our processes — finance to training to sales. I want to create a template that I can that I use every time there is a new job to do. When training is booked for example, I want to create a new sheet, add the date of the training and have all the due dates automatically calculate. I…
-
Does Smartsheets have a Google PERCENTRANK function equivalent?
Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function. We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list. The below image shows how this is done today in Google. The user…
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Data Uploader - Expressions & Repeated Updates
Hello, I have three questions regarding Data Uploader. 1) In my source excel file I have First Name and Last name. I tried to build an expression to concatenate the fields (used =[First Name]+" "+[Last Name] but returned UNPARSEABLE which I would assume is because I am not referencing the line number. Is there a way to put…
-
Reminder Escalation
Hello there! I set a reminder in the grid view to inform the project owners of the 4 teams that they know before the start date, if they don't change the status to "Complete", they will be reminded every 3 days, if they change, it will no longer Remind. Now, I want to set up an upgrade reminder based on the previous…
-
How do I give an outside user access to ONE row of a spreadsheet?
Here is the deal. I run a wedding video studio. I just made a smartsheet questionnaire (form) to have all of our videographers answer from the smartsheet app on their phones at the end of the shoot to inform the editors of anything they need to know about, etc. One of the questions asks them to upload photos they took from…
-
% Concluído x % Planejado
Olá, como fazer para criar 2 colunas com calculo de % de conclusão? Eu precisava controlar nos cronogramas de projetos o "%" concluído x o "%" do que havia sido planejado, como tem no project. Alguém consegue me ajudar?
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
Automatically uncheck column based on date TODAY()
How can I get columns unchecked automatically when they meet a date criterion? For example, all tasks checked today will be automatically unchecked tomorrow because the calendar date has changed.
