Is anyone out there using smartsheet for social media management and client approvals? We are dealing with a high volume social media content calendar that requires client approval on social media cop…
Hi, I have a column on my sheet which is the contact list. However, in the webform it does not show as a contact list. So I had to go and make it a dropdown with the exact same options as the contact …
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with …
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 li…
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…
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 manua…
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?
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 s…
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…
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 li…
