-
Equipment Sign Out Form
Hello! I was wondering if someone could help me build a sheet/form combination for signing shared equipment in and out of a warehouse environment. This is the kind of functionality I'd like to get out of the sheet: * Users would be have their name and the date populated in a form automatically * Pieces of equipment that…
-
How does linking work?
Hello, I am new to the Smartsheet world and I just started using this for my projects but I do have a question on how the linking works. I tried linking several project schedules into one integrated plan but everything I was changing on the master, was changing the original plan. Is this a true statement? Or am I wrong and…
-
Issues with a crossheet Countif formula
Hi everyone, I'm trying to create a formula to count how many datasets were processed in a month. I've tried the following: =Countif({Datasets},Month(@cell)=12) and I get an Invalid Data Type Error =Countif({Datasets},ISDATE(@cell)) returns the total of all datasets processed, so I know it's reading correctly as a date...…
-
Automated Update Request rule is in red font
I created an update request to be automatically sent today @ 11AM Central time. The time has come and gone and the request criteria is now in red font. It appears the request was sent, but why is the criteria in red font now? My "Contact" column is a contact list column. All fields are contacts with valid email addresses.
-
Overwriting someone else's work
Hi, While I was working on a row, adding data, I notice another user was viewing the sheet. I proceeded to complete my row and saved it. Few minutes later it was gone. The other person somehow was using the same row ant the same time and she Inadvertently overwrote my work. How can we avoid this? Thank you.
-
Activity Log: how to understand
Hello again, I need a little help with trying to find out what user is doing via information from Activity Log. If you look at the attached screenshot, activity log says that some user added picture via webform, which is clearly stated in relevant column and is indicated by mobile phone icon on the right hand side. My…
-
Filter Alerts&Actions
We are now working with quite some alerts and actions on one of our sheets and I am a great fan of Time Based Triggers, but when working with the Alerts&Actions table I find it more and more cumbersome. Is there a way to filter the list? Something like tabs for "Reminder", "Approval requests", "Update requests" and so on...
-
Are forms considered links?
I was just made aware that each sheet that is created in Smart Sheets has a 5000 link limit. Is a form that fills a sheet considered a link? If so can a I delete a finished row to provide more room?
-
Tracking Progress
Is there a solution that can be shared to assist me in sharing progress at intervals? For examples, I have a dashboard that lists the projects and the % completion, at any given time. I would like to have that dashboard, show (let's say) % complete on 12/31/18 then % complete on 1/31 etc. There is a need (want) in our…
-
Hierarchy
Can I create parent and child rows in all columns or just the primary column?