-
#Invalid Data Type
I have a successful formula in a sheet summary that is as follows =AVG(COLLECT([Prototype Lead Time (PO DATE and Ship Date)]:[Prototype Lead Time (PO DATE and Ship Date)], [Target Ship Date]:[Target Ship Date], IFERROR(YEAR(@cell), 0) = 2020, [Target Ship Date]:[Target Ship Date], IFERROR(MONTH(@cell), 0) = 1, [New/ Add'l/…
-
Why do my Index Match fields not show the results on Reports?
I have some reports from a sheet that populates a few fields from an index/match formula. On my report, the data doesn't come through. It shows #INVALID REF even though the data is correct on the Smartsheet. Also, it seems like the report isn't updating when those fields on the Smartsheet are updated. I have some other…
-
How to place a sheet link on a report
This discussion was created from comments split from: How to place a Sheet Link in a Report.
-
How to display unique dates from a sheet (source) to another sheet
Hi, I tried searching on this topic, and found a formula that worked for someone else. =IFERROR(INDEX(DISTINCT(COLLECT({Column 1}, {Column 1}, AND(ISDATE(@cell), @cell >= TODAY(-45)))), [Row #]@row), "") While I am trying to figure how to use it for my needs. My sheet has column name "Visit_Date" with listing of dates My…
-
check column against another sheet of applicants
This discussion was created from comments split from: Using an OR in COLLECT.
-
Not receiving update requests
Hi all, People informed me that they are not receiving the weekly update requests that are set up via an automated workflow. I have set this up for people external to my organization so they can update the rows that are assigned to them. They are not shared to the sheet behind this. However, the settings for the workflow…
-
Importing Excel Files
Hi All! Does anyone know why sometimes it shows " ' " in a cell when an excel file is imported? I´m having a hard time when it happens because VLOOKUP formula cannot find the information ... Thank you & Regards, Camila
-
Is there a burn down/burn up reports/charts that we can get from Smartsheet?
We are using MS Project and we can produce burn down/burn up reports/charts. Can we do the same in Smartsheet?
-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
Moving from Asana to Smartsheet
Can anyone share their experience in moving from Asana to Smartsheet? I'm looking for examples / visuals of what things looking like in Asana vs what they can become in Smartsheet. I've tried googling & looking on YouTube, but really only finding things about integrations between the two tools. Thanks!!