-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
Document review/approval tracking
Interested to hear if anyone has setup a process in Smartsheet to track document review and approval. SOWs and Cost sheets need to be reviewed and approved by multiple people prior to being reviewed by the customer. I'd like to embed this process into an existing customer tracking smartsheet if I can but am undecided on…
-
save/replace a sheet
How do I save a sheet to an existing sheet so the sheet url is preserved? Basically creating a point in time snapshot sheet each week but I want my colleges to use the same url to view the snapshot
-
Vlookup/cell linking
Hi All, I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a limit to the number of columns to 'look at' (which is 85.) This is the last formula that I have which works. =VLOOKUP(TODAY(), {1. DOR (Pull-out) Range 1}, 85, false) I…
-
shared with Active directory user
hi, i already integrated office 365 apps with smartsheet. i have question - can i share file with active directory user ? right now , for sharing content, i have to add that person on sheet. i need active directory integration with smartsheet so i dont have to add manually on sheet.
-
Export and Import
How do I Export a Smartsheet to edit and add items and then Import it back into Smartsheet without creating a new Smartsheet?
-
Adding Task Name to Right Side of Bars
I have an existing sheet that used from a template. It was imported from Project. There are currently no task names beside the bars in the Gantt chart. Is there a way to add the task name to show up to the right of the bars in the Gantt view?
-
Expensive Smartsheet!
We are a small company and we need use of just ONE sheet to be able to send to customers for them to be able select drop-downs (and a little bit of free-type) to create a bespoke item. Looking into the pricing etc on Smartsheet it is going to cost us £684 per year!! Is there any other way that we can do this slightly…
-
Product Selection using Contacts
Hi Just thinking aloud... is there any reason why I couldn't import my product inventory into 'contacts' and use the 'contacts' feature as 'products' and be able to select multiple products in one cell on a row? And then do counts of products within a sheet or a selection of rows? Thanks Cheers Richard
-
Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…