-
Copy New Row, Delete Old Row
I have a quick question. I have a process by which a row gets copied (from Sheet A) into another sheet (Sheet B). Since there will be duplicate rows in Sheet A, I'm wondering if there is a way in which when the row gets copied into Sheet B, a row can be deleted if another already exists? Essentially, I'm looking to avoid…
-
A formula pulling Time from a System-Generated column does not stay consistent. Please help!
I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours. For example, the screenshot is showing it accurately. But it will randomly switch to…
-
Dashboards
Am I the only one who truly hates the new Dashboard UI? Since the new UI was introduced, it takes me at least 5 additional clicks and much more time to create a new dashboard or modify an existing one... I used to be able to "Save as New" an existing dashboard and modify it for the project, while keeping the layout. With…
-
Is anyone facing issue with the new Smartsheet dashboards?
Hi Everyone, The new dashboard is not working for us. It is taking ages to load (let alone edit). Is anyone else facing similar issues? Regards, Abhiraj Joshi
-
New to Smartsheet. trying to figure out a formula
I am trying to figure out a formula that will help me track data. I work in construction so I think this will help me out. Example, I have 100 duration days to complete interior framing. I have gone through the schedule a picked what is interior framing and that will give me a % complete of what is done. Now what I am…
-
Vlookup Contact List... Recognition after Save
I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter…
-
How to return more than one value with multiple serach values with vlookup
Hi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2 and ID3=Result3 and in ID column I write 1 2 or something like this and i want to…
-
IF and OR nested functions for setting Due Dates based on Project Size
Hi folks, I've been Googling around to try and find some information regarding my challenge. Basically I need to set up this formula to assign a Projected Due date based firstly on the Date of Submission (Date Column) +5 days for a small project or +10 days for a Large project. I have columns filled through for entry for…
-
Dashboard/Report link issue
Hi everyone, A person on my team has created a dashboard with a report widget that has a link at the bottom on it. The report itself has over 700 line items, which is over the 150 max per this article: https://help.smartsheet.com/articles/2482269-using-report-widgets We would like to remove the link. Alternatively, how do…
-
Custom colours in grids
Hello. I love that custom colours can be selected by choosing the hex code or RGB values. This is especially great for the dashboard views with the graphs, titles, etc. One problem though is that we do not have the same option in grids. There the standard colours are the only options. Is it possible to add this to grids,…
