-
Using COUNTIF on a Range with Cross-Sheet References
I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet. The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF formula works but this destroys the advantage of using a VLOOKUP formula in the first…
-
Dashboard: Loss of images that existed on my report
In our Smartsheet set up, we provide photos of users that appear with their name (in assigned tos, owners, etc). These photos will appear in sheets, reports, etc. However, when we use a given report or data source in a dashboard, the image/photo is removed. Is this a known issue or is there a setting/checkbox we need to…
-
Sumif across Children and Grand Children
Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here are the formulas I have been trying: SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50)) => result to #UNPARSEABLE SUMIF(CHILDREN($[Payment Status]27),…
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
-
Embedding Tableau Public link to a dashboard
Hi there, I'm currently operating on an Enterprise level version of Smartsheet and experiencing an error with my dashboard. Does anyone have experience embedding a Tableau Public link directly into a dashboard via widget? I see that this is an option and have tried both the link & embed codes, which both return the same…
-
IF COLLECT / MATCH COLLECT / INDEX COLLECT / VLOOKUP ?
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS. If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level…
-
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…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
If cell is empty or blank,
Hi, I have currently formulated the following formula, =IF([Days (Difference Forecast - Baseline)]1 <= 5, "Green", IF(AND([Days (Difference Forecast - Baseline)]1 > 5, [Days (Difference Forecast - Baseline)]1 <= 10), "Amber", "Red")) which is working efficiently, but problem occurs when the cell is empty, and it show me…
-
RAG Status - Formula
Hi, I have currently formulated the following formula, =IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Date]1 - [Project Status %]1 <= 0.75), "Amber", "Red")) which is working efficiently, but problem occurs it shows me the…
