-
Data Import in bulk from Excel
Hi, Can anyone suggest how to import the data in bulk from excel, the number of data is around 37000. I can see that we have limit upto 5000, On Smartsheet I have to weekly import the data for the production. Copy and pasting is also not working as we have limit of 500 data at a time.
-
Update a cell in a column with data from a different columns
Hi, I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me! =IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval",…
-
Graphs 2 variables
Hi I wanted to know if anybody had tried to this type of graph in Samrthseet and if it's possible? Thank you for your help!
-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
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…