-
RYG Roll-up
Hello, I am trying to create a formula that shows a green ball only if all children have a green ball. Thanks.
-
IOS app not opening web forms
I have built two web forms for use on our production floor. I have an issue where the forms will not open in the IOS app. The URL opens if opened whilst in smartsheet on the PC of when click the link from an email, but just wont open in the IOS app. Any advice? Anyone else had this issue. Thanks Jon
-
SIGHT Metrics
I am part of a PMO and we track all projects on one sheet. The PMO covers multiple lines of business within our organization, thus I have a Sight set up per line of business. In each Sight, I would like to be able to show the number of projects in each RYG status. What is your recommended approach for doing this? I've been…
-
calculate next calendar friday
Hello, I am trying to come up with a formula that will calculate the next calendar friday after a minimum 10 working days from my processing date. I've had help from Craig to get this formula. How can I modify this formula to accommodate the minimum 10 working days before returning the next Friday? =IF(WEEKDAY(Orderby6) <…
-
Excel to Smartsheet WORKDAY formula
Here is my excel formula I use to find a FRIDAY shipping date. =WORKDAY($T1165,-10)-1+(WEEKDAY(WORKDAY($T1165,-10)-1)>=6)*7-WEEKDAY(WORKDAY($T1165,-10)-1)+6 I changed to this in Smartsheet but doesn't work. Any advice? =workday([start date]12,-10)-1+(weekday(workday([start date]12,-10)-1)>=6)*7-weekday(workday([start…
-
Formula reporting from drop down list
I have a sheet that is used to track downtime in our production faclility. Essentially an electronic form is used to record how long the line is down in minutes, based the length of time reported I have a formula that makes an associated cell record if the amount of time represents a "major" or a "minor" stoppage. 5…
-
Holidays error
When I enter my workday formula =workday(receive5,-days5) it works fine. However when adding holidays, =workday(receive5,-days5,[holidays]) then it does not work. Do I have to enter the holidays manually? Does it not link to my holidays list I created? What am I doing wrong? thanks Mike
-
Free Collaborator Access
We have a Smartsheet and have created some reports for others to update. The others are not licensed users, and we just need them to update certain fields periodically. We've given them "Editor - cannot share" access to their reports, but they are unable to enter or modify any data. Shouldn't a free collaborator be able to…
-
Consistent Column Widths
I saw from earlier posts there seems to be no way to specify column widths. I'd like for fields of like-data-types to have consistent widths. Is there a way for this to be possible?
-
Retaining Deleted info
I was attempting to copy rows to another page, but instead, I moved them. Problem is I didnt realize it until deleting the rows from the previous sheet. I could not undo anything since I already switched to another sheet. Is there any way of retrieving that info deleted?
