-
Showing completed items 8 days after completed
Hello, I am trying to make my report so that if an item's status was changed to complete in the last 8 days that it would stay in the report so that our client can see it was completed within the last week. I've figured out a way to do it in the sheet but not in the report. I there a way to do it in reports?
-
Date Formatting
I'm trying to create a rule so that if an 'install date' is before a 'product received' date then the install date will highlight in red. Any ideas on how to do this? I tried rules and filters, but it wants be to chose a date for my condition (not the date in another column). I did this a long time ago and I created a…
-
Upload Json file data into smartsheet
I need some help in passing json file into smartsheet. I want to pass all the values from file and load exactly same values or some columns as per my need in smartsheet. I am using below syntax in the body to populate some columns as per my need {"cells":[ {"columnId":8423944366647172,"value":false},…
-
Performing Calculations if Cell = ""
Hello Community, I have a question on what the optimal solution is to a calculation I would like to perform. Here is what's there: In one column I have job title - based on if that cell = "[title X,Y...]" then I'd like to perform a calculation based on four other columns that have calculated values in them - but the weight…
-
Employee Objective and Performance Reviews
I am looking for a real-world example of someone using the employee Objective and Performance Review Template for an IT manager? Do you find it useful and easy to use for managing your managers? Anything you can share would be greatly appreciated.
-
Pie Charts and 2 rows of data - Possible Bug w/workarond
Just submitted this to Smartsheet, thought I would share with the community to see if it was indeed a bug, or if anyone else has experienced the same? Bug: I have a report with two lines of data showing... When reflecting that data on a dashboard, I am unable to select a pie chart when there are only two lines of data from…
-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…
-
Logging into Smartsheet
Hello all, We have 3 licensed users, and one of my colleagues set up a free trial it has now expired and he would now like to transfer his sheets to another log in for him but using the same email address. I have tried deleting the account then going in to 'sign-up' but smartsheet seems to remember his email address and…
-
Getting Started Tutorial for Customers
We have built out a 'project portal' of sorts made of up several sheets, reports, and dashboards. I'm looking for anyone who has done the same and/or built a 'getting started guide' for customers to understand how the project will be managed utilizing all these components (information, status, collaborations, etc.). Anyone…
-
Value in same row, different column
Hi. My ultimate goal is to list the next upcoming task in a project. I have found a way to find the date of said task by creating a new column and searching for the minimum due date of all tasks which are not yet checked "done" (this was a ridiculous undertaking in and of itself, but oh well). My next task is to return the…
