-
Change the value of a cell from the formula results of another cell
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete…
-
Bulk Document Attahcment
Does anyone know of a way to attached documents to a Smartsheet programatically? I have files that are named with a tag that is also unique to a specific row in my sheet (thousands, so manual attachment is out of the question). I would like to be able to periodically attach documents based on this tag as my sheet grows and…
-
Date/time and year
Im trying to put together a simple Gannt chart for a project in the UK. How can i make a change to the date so it reads day first, then month, then year?
-
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…
-
Columns with checkboxes are not lined up properly with the heading. Why?
Columns with checkboxes are not lined up properly with the heading. Why?
-
Release Notes for July 11th Upgrade
Hi Smartsheeters - In case you didn't see the link to the release notes @ the tail end of the blog post announcing the latest feature release, you can find the comprehensive list here: https://www.smartsheet.com/release-notes Going forward, we will be publishing detailed notes with each major release (as opposed to just…
-
My Smartsheet Contacts vs Group Management
In using the Assigned To column, I found that several Contacts did not have their First and Last name fields populated. So, I went into My Smartsheet Contacts and updated all of my Contact items so that all have their First and Last name fields set. I then saved the sheet, closed it, reopened it and went back to the…
-
F4 funtion in excel
Could someone tell me what the equivalent in smartsheet is for the F4 funtion in excel that fixes the cells within a formula?
-
I don't understand why I'm being asked to upgrade my account
Hi Today for the first time ever, we are being asked to upgrade our account. We are using 1 of 4 of the licenced users. I also do not have the transfer paid account link in my account settings. I want to transfer this to my manager.
-
Resource mgmt - Allocating less (or more) than 8 hours a day for a resource
All. My team spends 15% of their time in other activities like meetings, career development, system support, etc. I would like to use Smartsheet resource mgmt functionality but only allocating approx 6 hours a day for my resources. How can I do that? Thanks
