-
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…
-
Update cells via form or secondary sheet?
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I need updated? If that isn't possible... Is there a way to make an automatically…
-
Is it possible to use a formula to help users complete a form?
We are asking for updates to quality documents. The form asks for the document number and the title. Is there way to auto-populate the title in the Form once the number is entered?
-
How can I print my full chart from my dashboard.
HELP!! I am having issues attempting to print several charts from my dashboard. They are fairly large charts and I would be fine if they were on multiple pages. However, when I attempt to print them, I am only getting portions of the charts. And the very first chart is for some reason adding a huge space between the top of…
-
Conditional Linking?
Hello, I was wondering if there was a way to unLink cells if a condition is met, i.e. if Column1 is checked then UnLink all cells in all rows this would be to lock values coming in once checked or if that is NOT possible ... If a value that comes into a linked cell (from another sheet source) is say $10 and I set up an…
