-
Automatic Deletion
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the data. They propose that a notification is received when someone fills out a form and the…
-
Fleet vehicle maintenance tracking template with alerts build in
good day i am looking for a fleet vehicle maintenance tracking sheet with alerts anything out-there thank you
-
Forms Permissions
I created a Portal/Dashboards with forms on them for employees to collect data. If they do not have edit rights to the underlying sheet, can they still add via the form? Also, is there a way to catch a duplicate entry?
-
A user can't access sheets
Hi, Since last week one user can't acces to sheets anymore. -She can't see old sheets neither new sheets, -She see's the list of sheets she should have access but can't open it -Her team can access -Her count is active, i also activate a licence for her since she report the bug, -We try in private navigation and after the…
-
Cell Linking Issue
Hi all, I am new to this community but have read numerous feeds posted here and found them really useful. I have now run into a problem of my own that requires some help. I have created a form for our business to complete. The completed lines (Cells) are then linked to another sheet for data collection. The problem here is…
-
SUMIFS Statements
Hi I have been having a lot of trouble getting SUMIFS statement to work always having the result unparseable - =SUMIFS(FTE2:FTE589,Fund Source2:Fund Source589,"MEMS",Unit2:Unit589,"Aquatic Environment") I have tried multiple times with just the column title and also selecting cells - I can get the statement to work…
-
Stuck trying to rollup with index, vlookup, and match
Hey folks, any idea how to pull this information onto another sheet horizontally? Basically, I am trying to consolidate some project information as seen in the "Source" screenshot. This particular sheet has the status for multiple items for the same project, but lists the same project on multiple rows. You can see this in…
-
Attachment
I know on 26Aug19 brought the new Attachments in Right Panel logic. Question from a consistency perspective, is there plans to create this same look and feel in reports as well. At the moment, if you are in a Sheet, you see the new attachment logic, however, if you are in a Report, you see the old style attachment logic.
-
How to deselect a radio button answer option in web form?
Is there a way to allow a user the ability to deselect (or unselect) a radio button option after making that selection (i.e., clear out their choice and make no selection after already having made the selection?)
-
If, Or, And
I'm trying to work an if/or/and statement to return one of 2 numbers. It would look something like, If X or Y or Z and A or B then 0 else 8. It has me completely stumped my results are always unparsable. Do anyone have a direction to point me in? Any help would be greatly appreciated.
