-
Opening Worksheet in New Browser Tab
When navigating through and opening several sheets, it would be helpful if there was the ability to right-click on a SmartSheet and open a sheet in a new browser tab. Currently we have to open a new browser tab, navigate to smartsheets, then find/open the sheet.
-
Within a SUMIFS statement, can you extract the hour from a timestamp and use it as criteria?
Hello all, I have a problem that has been driving me mad - I would be grateful of some help! I have a spreadsheet where: Column A contains names (text string) Coumn B contains costs (numbers) Colum C contains a timestamp in the format dd/mm/yy hh:mm:ss I want to be able to create a formula that says "add up all the costs…
-
Finding text between two parenthesis
I am trying to pull the text between two parenthesis and place in another field. In the screen shot attached I am wanting to get the data between the two parenthesis in the "Requested by (NetID) field and place it in the "Requested by NetID"). In other words, I want "dj32" to be in the second field. Anyone have any ideas…
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
-
How do i share a sheet with the community?
Hi Team, I saw an answer to a comment by one of the community members on here who shared a sheet with a link. By the looks it was a dummy sheet that you could click on cells and see the formulas etc. I have five sheets I use with personal customer’s information, i have set up a dummy sheet i want to share with the…
-
Accessing HomeRessource of specific Users via JavaSDK
Hi there! I'm developing a statistic tool for monitoring file creations with smartsheet in my company. First of all, thanks for the brilliant Java SDK, that makes live so much easier when trying to integrate Smartsheet in other applications! Currently I'm at the point where i have to access every user's home directory, to…
-
Attachment Permission
Is there anyway to share a sheet but not certain attachments? I have all my sharing permissions set but there are certain attachements I do not want available to certain users. Smartsheet is working great for my team with the exception of attachments.
-
% Calculations On children
HI Community I have A Quick Question On % Calculations I have a Payment Sechdule Which has a a main Name For example Wall Framing Under Wall Framing i have indent Wall framing on Floor 1, Floor 2 etc, And i ran =SUM(CHILDREN()) To calculate Total We charge on Wall framing Now For my customer i want to send only The Main…
-
Counting rows with multiple drop-down options
Hello, I would like to count all the rows on a sheet that meets certain criteria. The sheet has a column [Project Status] with the following drop down items: Tentative Confirmed In Process Delayed On Hold Punch List Completed Cancelled RMA Processing I would like to get a total count of all the rows that have open…
