-
Copy/Paste Not Working Today
Today I copied data from and Excel spreadsheet and tried copying it to corresponding cells in a Smartsheet grid and the paste function didn't work - no data was pasted. I've copied and pasted data into sheets many times in the past and have never encountered this problem until today. Is anyone else having this issue? Can…
-
Specific Mailalerts (triggers) not working today
Hello everyone Today - like many days before - I added and edited data im my sheet and (tried to) trigger workflows. All of a sudden today mails are not delivered like they used to all days before. I changed nothing severe (only moved the sheet to a workspace, but already undone it). It only happens within one specific…
-
How do I get around approvers being on vacation in a workflow?
Hi there, We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given project to gain approval.…
-
Sum column total from another sheet if checkbox checked
Hi, I've seen this done on same sheet but I'm having trouble accomplishing my goal trying to pull from another sheet. What I'd like to do is on "New Sheet 1" have the "Done" Column total update from the "To Do" Column from "New Sheet 1b" when the checkboxes are checked. Thanks in advance!
-
Report for yesterday
Hello, I hope someone can help me. Maybe I'm blind, but I can't find a way to make a Report for only yesterday, I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum]. Now I want to make a report, that shows only the rows from yesterday. Not today, not further in the past. I want to…
-
Project Management and Stakeholder Logs
We're using smartsheet to track a land acquisition project for a utility. Each row will contain a contact, parcel features, a dates of progress. We need a way to manage daily communication and updates. We have considered using comments and a remarks column. Is there a better solution? Thanks!
-
Meeting agenda item reports
We're piloting the use of the template set including the past & future agenda item reports. The issue is the reports aren't pulling the correct data. I added a column to the meeting sheet that is the meeting date (function pulls it in date format from the parent row where the date is entered as text) so each child row is…
-
How to remove "Fill out forms with the Smartsheet app" from top of form?
I created a form, and emailed the form link to several persons. I want the persons to simply click on the form link, which will open the form, then complete and submit the form. To keep the process simple, the persons do not have the Smartsheet app. When the person clicks on the link, at the top of the form the user will…
-
How to build analytics for dashboard on a data sheet?
I had a couple of analytics columns on a dashboard that were locked and hidden, where I had a bunch of COUNTIF(S)s and SUMs (as a workaround without pivot tables) to create some charts for my dashboard. Turns out that when people change the sort, these analytics columns got messed up, and now my data is all over the place…
-
Cell link indicator
Hi everyone, Is there away to hide the cell link triangle indicators? Most of my cells are linked and it obscures the data. Thank you