-
Moved data from one sheet to another sheet - now its not showing up
I just moved data from one sheet to go onto another sheet and now it’s completely gone and not showing up. I refreshed and went back into the sheet the information was suppose to be moved to but it’s nowhere to be found. I am trying not to panic.
-
NOt allowing me to add more rows
Good afternoon I am trying to get my smartsheet to 727 rows but it is stopping at 297? Very strange. Does anyone know why I cant add more rows?
-
Capturing Approval Dates
I didn't see a solution to this anywhere, but I was wondering if there is an easy way to capture the approval date and put that date in another cell. I'd like to use this as a predecessor to another task, and if the approval is late, the other dates adjust. I want approvers to easily see how their delaying approval of a…
-
Validate if the Hyperlinks in the cell are a valid URL's
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. Thanks
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
Image in Dashboard
I am working on a template for my dashboard that would show an image of the project in the top right corner. Now this image will change for each project. The goals is to have some of the data for the dashboard pulled from a Metric Sheet, I have added the image to a cell there and figured I could use the Metric widget to…
-
Overwriting lines
We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time. Anyone else experiencing these issues?
-
Automating RYG balls to change colors
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…
-
Reassigning tasks in bulk to a New Resource
Hi, I have assigned multiple tasks to Jane, but I a new person is now taking over all of Jane's tasks. So is there a way I can bulk assign all the tasks and the sheets to the new person? Thank you!