Discussion List
Subitems "Child Tickets" Automations
Hello, I recently started a new intake system within Smartsheet for our Training team. The way they structure tickets is unique. They have Parent tickets and Child Tickets. The individual requesting assistance from the training team can submit a ticket, but that ticket could have several deliverables . Each deliverable is…
Why am I getting an error with Bridge when I try to pull a list of sheets within a Workspace?
I am trying to build out a workflow in Bridge that uses an API to make a call to the workspace and pull all of the sheets within that workspace. I am using bridge with the correct account that has owner access to the workspace and I have the correct authorization key put int he correct form parameters. The workspace I am…
Can you save a comment for later?
Hi all, I have noticed that once you read a comment you can't "save" it or mark it as unread. I find this very useful to remind myself of things I can't reply to straight away, but want to go back to. Is there a way to do it that I am missing?
Averageif within a date range
I am trying to get the average cost of contracts written within each month of the year. =AVERAGEIF({R2 Scheduled Date}, AND(@cell >= Feb2, @cell <= Feb3), {Total Gross}) is returning "$0.00" Any suggestions?
Help configuring our SAML with ADFS
This discussion was created from comments split from: Setting up SSO with ADFS.
Smartsheet reminder/alert via SMS
This discussion was created from comments split from: Smartsheet reminder/alert via SMS.
Removing Zero from my results
Can anyone see what is wrong with this equation. Trying to remove zero from my column when nothing has been done. =IF({08 - Estimating # of Pricing} = 0, INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)), "")
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
[UPDATED] Community Reward Program 🏆
Hello Smartsheet Community, We value the way you support and encourage one another and want to recognize your efforts with our Community Reward Program. As you engage with the Community you'll level up and unlock rewards including swag, and access to previews and beta features. Curious? Read on to learn more about our…
Return value at the intersection of a row and column
I am new to smartsheet and haven't found what I'm looking for through search. I have a sheet that is contains a table of cycle times. This table is for reference and the values in the table will be used in a different sheet. I want to be able to return the value that is at the intersection of a row and column based on two…