Hello, I am trying to add one additional condition to this statement below, but can't seem to figure it out. Here's what I have currently (which works): =IF($[Row Identifier - Budget]@row = "Parent", SUMIF(CHILDREN([Alt Cost Center]@row), "", CHILDREN()), "") And I'd like to add an additional option that says if [Alt…
When connected to my company's network, only particular team members can access Smartsheet. For those that cannot access it, neither the email invitation or direct login works. From the email invitation an error comes up that reads "This site can't be reached. The connection was reset". When attempting to access from the…
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
Anyone else having issues? I cannot update this column in any of my sheets. It just jumps to the next line of it you hit return it auto adds a full line.
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
Hi, I am able to connect my smarsheet data to tableau desktop app via API token. However, when I publish my workbook on my server, it prompts me to sign in with a user name and password. I am an SSO user on smartsheet therefore don't have a password. Can anyone please advise how do I get around this please? Maz
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
Hello, Is there a way to set up a Smartsheet workflow to directly message the target person on Microsoft Teams? Thank you, Luke
