-
VLOOKUP #INVALID DATA TYPE
I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an "invalid data type" error. Here's my formula. =VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS Range 4}, true) [Workorder]10 is the workorder number I'm attempting to search in the {Platform MPS}…
-
Formula is changing after a date sort
Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this the formula =SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171) Changes to =SUMIF($Equipment16:$Equipment171, "VUTEK", $Tue16:$Tue171) Thus not including any data from rows 4 thru 15. I have locked the row with the formulas…
-
Organizing/Sorting Workspaces
Hello Fellow Smartsheet Community Members, I am wondering if anyone knows if it possible to sort items in a workspace by the item type. I have a workspace that has a mixture of sheets and reports. Ideally, I would like a way to group all the reports together and all of the sheets together. An anaology is clicking the…
-
Creating Different Update Request Formats
I send update requests every day. However, when I send them, I have to keep removing some of the columns as those that I remove are not necessary for the person to see. Is there a way that I can save an update request format with those columns removed so I can quickly choose the right formats for the specific person I am…
-
If cells in formula are blank, then leave the formula cell blank
I have three main columns: Planned Start Date, Planned End Date, and Date Completed I am utilizing the formula below to determine which tasks are done and late in the status column. I would also like the status cell to be empty if the date completed cell is empty. How can I do that? For some reason ISBLANK isn't working…
-
Screen Capture of Sight
Hi, As it is not possible to control the printing of a sight (it only prints within one page, which is not usefull for larger sight), does anybody know a screen capture tool that would scroll throught the sight and grab all the data? I have tried several (on Mac) but not seems to be able to scroll automatically and grab a…
-
Email Notification View
We use Smartsheet notifications and receive emails frequently letting us know that a task was completed, and it is now our turn to work on a task. We use MS Outlook as our email client, and within here I like to use the preview pane. When I receive the Smartsheet notification, I cannot see the task that is ready for me to…
-
Formulas with Conditions
Hello, My goal is to have a formula populate the dues dates with one condition. Currently Drawing Due Date is populated 2 weeks from Order Date If the "Type" Column is "Q" then I need the Drawing Due Date to be 1 week from Order Date. Current Formula: =$[Order Date]289 + 14 Thank you for helping me with this in advance.
-
Formulas
I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…