-
Send an Email Form Intact to Others
Hello - I have created a form to capture nomination information for an award. The link is on the web where people would enter their information and submit it to me. I then have to send the information to a committee to review and I would like for them to be able to see the form and not the grid as it is harder to read and…
-
How can i tell if an email in outlook was sent to Smartsheet?
I use The Smartsheet for Outlook Add-in frequently and it is a great tool for uploading email conversations and attachments, however there are instances where I'm not sure if I have already attached an email. Is there a flag of some sort that can indicate if an email has been added to Smartsheet, and if so where it was…
-
Smartsheet moving rows
Hello everyone, Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no conditional formatting so I have no idea why it is happening. If anyone has any help…
-
Update Status in task list after form submission
Hi Guys, How can I update the status of a task in a task list after submit a form? I just see move row and copy row, but I there is not an option to update a specific record for in a sheet. Is this possible? If yes, how could I do it? Thanks, Andrea
-
Percentage increasing by 100
Hi all, I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet. The strange thing is, this is only happening for one of my team. When i do it, in the exact same…
-
Getting Oldest Date based on another field
I have created a Metrics Sheet to roll up the oldest date based on another field. I am trying to have it return the oldest date in the "Date Sent to CSOS" column if the Date approved by CSOS column is blank. I can also use the if CSOS Review column is Submitted but I can't get either one to work properly. Does anyone have…
-
Rollup summary of data
This is probably a very simple formula required but I am struggling with it. Can somebody please assist? We have a number of clients on one sheet where we track different trades budget vs. actual for each client. e.g. Plumbing, Electrical, Carpentry etc. We want to count up all the budgets for the Plumbing for all clients…
-
How to import/merge 2 Smartsheet projects plan into 1?
I need to import an existing project plan (call it A) into an already project plan (call it B). A is under a different corporate account than B. I have access to both. I need to merge the 2 project plans into 1. The question probably has been asked but I can't find a "real" answer. Thanks for your help!
-
Using a nested HAS formula within a COUNTM?
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management, IT, Applied Learning). On a separate grid, I am trying to identify the number of…
-
How to put formulas in smartsheet form without it automatically override as text?
When I use an automation workflow from a form question hidden as I have the formula as the default value of that question, how can I get it to work it's formula instead of it overriding as a text? So when I put in the formula in the default value in the form and when after the form has been filled, the formula is exposed…