-
Counting working days in a week
Hi everyone. I'm trying to come up with the best way to count the number of days that a project is being worked on in a particular week. You can see in my screenshot that ProductiveDays is counting the working days from 6/10 to 6/14. I've come up with a rather cumbersome formula that works and only requires that I manually…
-
Sheet Divider & Section Freeze
Hello there, I'm currently working on building a very simple timesheet to capture individual time allocation. I have a few columns (Reference Section - Reference Section.jpg) with the following information: * Month * Number of Days (within corresponding month, excluding weekend and statutory holidays) * Number of Reported…
-
Form help - one field per row??
Is there no way for multiple small fields to appear on the same line? I'm wracking my head for what feels like a simple issue... Building an entry form and want a section to look something like (ease of use). Field A [_____________________] Field B Field C [________] [_______] -instead of- Field A [_____________________]…
-
Creating a Simple Data Entry Screen and Ability to Search and Display Data Entered in the Past
I'm just starting to look at SmartSheet... does anyone know how easy it would be to create a simple data entry screen (maybe 15 fields) and save the data in such a way that it would be easy for others to search through the data that has already been entered? It's not exactly my use case, but an example would be a simple…
-
Sending Alerts to Contacts w/o Sharing
I have a sheet with information that is not confidential yet isn't information I want to share with all vendors. The managers who can view the sheet already need to see all of the information currently in the sheet. (As the owner, I have other information in columns hidden from other's views ) I set up alerts to go to…
-
Custom domain & branding for login page
Hi, I have a business account. Is there a way to create a custom domain for the login page as well as custom branding for that login page? For example: the Smartsheet's default login domain is app.smartsheet.com. I'd like to make mine app.customdomain.com and it have it look just like the default branding, but with my logo…
-
timing of the Run workflow:Daily ?
Hello, If I set the change action like below with "Run workflow:Daily", how the recurrence occurs? lets say, the requests come in at 9am, 11am, 3pm, 4pm, 9pm on the day, how the run works on the day and next day? Thanks, Hana
-
Pull the automated count of elements
Hi all, I noticed that when I'm creating a report using the What? button I select the column that I need to show, it automatically shows me the elements found for that column, and what a surprise that those elements contain the included count number. My question: Is there a way to get that counting number, instead of…
-
Need to Resize Window Linked Through Dashboard
I have a shortcuts widget on my dashboard. This contains links to Smartsheet items as well as other useful links. When a user clicks on the link, the linked window appears but it cannot be resized. As an example, I have a link to a project sheet. The sheet comes up using a small portion of the screen, with the Windows…
-
Limiting input in a column
Hi There, I was wondering if anyone knows how to put an entry limit on a column field. I am circulating a sign up sheet and need to limit the # of spots available on a particular time slot otherwise I would have an overflow which I could not accommodate Does anyone have any suggestions? Thoughts? Thank you
