- Scoring
Hello, I am trying to setup a Risk registry where user selects the probability (very high, high, low) and formula in a new column says if High, then score is 0.07. I then want to do the same thing with Impact (user selects impact high, low etc. A new column puts a score based on formula: if high, then 0.05). I then need…
- Forms Enhancement Request
I would LOVE if Forms could be accessed outside of the sheet. Grouped together the way that Reports, Sheets and Sights are. Is this possible?
- WOULD LOVE THIS FEATURE
For our use, it would be of great assistance if when you are within a workspace, which is housing, say 50 sheets, you could check all and using the actions button duplicate all sheets. I could then move those sheets to a different folder while keeping the data needed and deleting what isn't. We tried templates but our…
- Enhancement request - search visible rows only
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
- Forms customization
The required field indicator is a red asterisk. When we built a form, we mentioned that anything with a red asterisk is required - but we can't customize any of the text (including the asterisk) in the description. So the referred asterisk is black while indicating it's red. Perhaps it's minutiae, and the details sometimes…
- Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
- Month/Year to text
I am trying to extract the month and year out of a date column and join them to create a unique key. For example the value in the date column is 8/18/2017 I need a formula to return 82017 I can extract the month and the year without a problem, but when I try to combine them I get the sum of 8 and 2017.
- 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…
- Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
- 条件格式不修改铜rrent value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met. How do I tell SS to leave the current value as is if the condition is not met? =IF([Modified By]1 = Owner1, " ", Modified1) Background: Above…
