-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
Feature Request - 360 deg photo
Please allow us to link a 360 deg photo into a cell. Currently the cell will flatten the 360 photo in the preview (in the cell) and in the pop up window. Can we get the ability to link in a 360 photo?
-
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
-
samsung tablet
i receive this error when trying to load mobile app on samsung tablet . app has been working for the past year heres the error : could not complete this action . please check your network connection , refresh, and try again tried on two different networks still same issue
-
Countifs with multiple variables
I am trying to automate a tally of which SME's have worked an event with which countries. Ultimately, I created a column that lists the countries that participated in the particular event (ideally I would like to keep multiple countries in one cell per event), and hoped to use the "joined" column to reference the SME's…
-
Countif but only if?
So I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether or not it should be included in the "tally". Ultimately, what I am trying to do would be if the…
-
What's wrong with my RYGB formula?
Ok, I'm feeling really stumped. I have this formula for changing the color of the RYGB balls based on the number in a specific cell but it is returning an #INVALIDOPERATION on anything except zero (when the ball turns blue). Where am I messing this up? =IF([# of Days from Submission to Assignment]@row = 0, "Blue", IF([# of…
-
Enhancing Workflow Management on Consulting Projects
Hello! I need some help enhancing how we track our current projects in Smartsheet. I work for an engineering consulting firm. We have been using Smartsheet over the last 9 months to track tasks and manage workflow. The majority of our projects are labor-only. Due to the nature of our work with public agencies and…
-
IF / OR Formula help (#Invalid Column Value)
Hi everyone, I am trying to figure out a formula, that will show the following result: * If the completion date is before the due date, the green circle appears; or * If the completion date is after the due date, the yellow circle appears; or * If the completion date is blank, the red circle appears. The formula I have is…
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…