-
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…
-
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…
-
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
-
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
-
Automatically scheduling work on special days (typically weekends)
for my projects, weekends are not workdays. But, at the cumination of almost all the projects, special events (like commercial moves) must be scheduled on weekends - not during workdays. I'd like to set dependencies for all the related events, so that if a Saturday move gets rescheduled to another weekend, all of the…
-
Auto-Number Fields on Form Creation
Hi Is there a way of Auto-numbering Fields during a Form creation? Put simply can you automatically number questions 1, 2, 3 etc? Or can this only really be done manually by changing the column titles? i.e. 1 - Where do you live? (for example) Many thanks Nick
-
Question: Automated To-Do List by User
Is it possible to build a report that automatically pulls a to-do list for the logged in user from all open project sheets, or do I have to build a separate report for each user and send an updated link each day?
-
Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
-
formulas disappearing
I'm having an issue with the formula I created to automatically check a box disappearing if I happen to manually check that box. I have it set up so when a certain box is check marked this will cause another box to then be check marked. I'm wondering if there is a way to override the formula immediately disappearing when…
-
Working Days without Enabling Dependencies
Is there a way to plug in the Working Days criteria (non-working days, holidays, etc) without turning on Dependencies? I'm trying to build a sheet that recognizes weekends and company holidays as non-working days, but I don't need Predecessors or Duration columns. In the past I've enabled Dependencies then literally…