Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This…
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 VLOOK…
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 o…
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:$[Pa…
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…
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 …
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] wi…
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 pro…