-
Formula Help
Hi, Are you able to help? I have a column named "snag" which is a red flag check box, then another column named "PM" with drop down name initials I need a formula that calculates, when a Red flag is raised and PM name is "XYZ" the result is = ZZ number of projects I'm going wrong somewhere and can't get it right, see…
-
Rollup text to parent based on MAX of another column *SOLVED
Hello- This is a look up of sorts. I have a list of files. Each time i receive the file it is logged with it's package name and date. I can MAX CHILDREN the date and it rolls up to the PARENT, however, I cannot figure out how to have the package name of the max date rollup. Any assistance is appreciated!
-
SUMIF using a cell with a formula in it
OK, so my formula is this: =SUMIF([Customer PO]:[Customer PO], [Customer PO]2, [Value to be invoiced]:[Value to be invoiced]). I'm pretty sure it's correct, but the 'Customer PO" column uses a VLOOKUP formula which I think is what's causing a #NO MATCH error...? Is there any way to get around this?
-
Click Drag Attachment from Outlook to Cell
Is there a way to click drag an attachment, such as a .pdf or .jpg image file into a Smartsheet cell from Outlook?
-
Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…
-
vlookup w/ resources and dates
We are working on a manpower tracking sheet and trying to create a link from one spreadsheet to another, which will lookup a resource and then find the latest date that resource has tied to it. This will allow us to see when we have someone coming off a project and has not been assigned to another project (on the bench).…
-
Smartsheet Dashboards vs Live Data Connector Integrations
Hi everyone, Has anyone used the live data connector to integrate with another platform such as Qlik or any other? I know that SM now has the dashboard view, but I do not think it is as powerful as other BI platforms. From what I see, the SM dashboard is a very high level overview and does not give the level of detail that…
-
Do not show parent row in calendar view
Hi, Is there a way to set up hierarchy with several tasks and different dates, and not have the parent row's date, which ranges from the first to the last date in the tasks below it, show in calendar view? I want just the children rows to show, so to keep my calendar cleaner. Thanks for any help
-
How to calculate weekly GP on a gant chart?
Hello All - I dont believe this is possible with smartsheet - but I want to make sure before I purchase a one off. I have included a screen shot below to illustrate my goal. This screenshot is from a colleague who uses FastTrack for this one and only purpose. I currently have a master schedule that shows all of our…
-
Collect Criteria not being filtered
My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…