-
Webform - Comments on the bottom
On my webform it has a spot for comments (for the user), where do those comments go? they are not on my sheet - do I need to have a "Comments" Column???
-
Weekly Input for multiple data points at multiple sites
We have been tasked to gather weekly meter data: multiple meters (3-10) for each utility (water, electricity, natural gas) at each of the 60 plants. What is the best way to gather multiple data points from mulitple plants all at once? We are unsure how to format this correctly. The plants will have to entrer Meter Name,…
-
Using Smartsheet as the only tool vs SharePoint, shared drives and OneNote
Our department is looking at how we file electronically. We have used a combination of OneNote, SharePoint, Shared Drives and we just started using Smartsheet. Smartsheet seems to allow for all communications, files, etc to be stored there. Has anyone moved to using only Smartsheet for everything that has anything to do…
-
Resources and Duration
I would like to make the “Duration” column dependant on the hours needed and the team assigned to develop a task; something like “Hours (quoted) / Team (number of people)= Duration”. Is that possible? How can I do it? Thank you for your guidance.
-
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…
-
Export to letter formatted document
Has anyone tried building a sheet that would have a presentation level, letter format when exported? I'm looking to build proposals within Smartsheet, then I could cell link that final/approved fee into my project tracking sheets for cost comparison etc. In Excel you would typically do this via cell merging etc, but that's…
-
Using pointers for relative addressing
Greetings: Is this possible in smartsheet? (I have searched through the list of functions, a video on the use of cells, and the community but have not located any info on this.) Would like a formula to look at the current row's dependency and treat that value as a pointer to reference the value on another column in the row…
-
Enhancement Request: Allow NO non-working days in WORKDAY function
I would like a small improvement to the WORKDAY function. For the third argument, we can pass in a range of dates. I want to pass in 0 or false or some other flag to IGNORE working days. =WORKDAY( {date cell} , 15 , 0 ) would return the date 15 days from now, regardless of project or global settings for non-working days. I…
-
Auto Indent When Using a WebForm
I have some formulas on the 1st row and everything underneath are indented in order for the formulas to work. However, when a new entry comes in via the webform. The new row does not indent automatically. Does anyone have any suggestions? Thank you!
-
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!