Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Company administration level management of non-licensed users
We are using smartsheet to track staff resources across our projects, which only requires senior staff to be licensed users and collaborate, all other staff are listed as non-licensed users and won't ever need to use the sytstem. It would be easiest for us to have full control of their profiles as admins when they are…
Counting Child Rows of Un-Checked Boxes
Any tips in how to count child rows where the check box is not checked? I tried CountIF but it does not seem to work Thanks Elaine
Can you set a "Do not remind if..." rule on alerts?
Hi, I have set some alerts to remind of upcoming service dates. Is there a way to set up "Do not remind if.." ? For example, I would like the items that have a column box ticked to not be included in the reminder. Cheers, Ben
Conditional Formatting based on a cell text formatting
Hello hive mind. I am familiar with IF statements and Conditional Formatting, but I am not seeing a way with either of those for the followng. I would like to set a Conditional Formatting Rule to highlight a row to a certain color if the text in a particular cell is in bold. There does not seem to be a way with Cond. Form.…
Contact List - Assigned to - automatic alert?
Hi guys, Is there a way to automatically 'alert' someone if they are 'assigned to' a task using a contact list column? Would love to hear a workaround if you have found one. Cheers
Create report based on a conditional format in sheet
We are trying to build a report that looks at the format of a cell in the main sheet. We are using the conditional formatting option to set a specific cell's format based on the combination of various other fields in that row. Now that the sheet is correct, we are going to the report builder to create a report that looks…
Add number of months onto a date
I have a sheet that summarizes all of our projects. I want to add the projected term of the project (in months) to the kick off date of the project. Here is what I came up with but it is not working: DATE(MONTH([Kick Off]1) + [Project Term]1) Is there a formula that I can reference the date on one cell and add...say "6…
Continuously moving inventory - keeping a record without overwriting current information
Hi there, We have an existing Inventory database in Excel that i have imported successfully. However now I need to figure out - if I can - how to 'track' the movements of any given piece of equipment. For example we have a Computer Monitors that are 'loaned' to customers every so often. I woud like to keep a 'log' of the…
Web Form Question
How can I deactivate a web form and issue a postponement or will be rescheduled message at the same time?
Counting non blank cells
How might one count non blank cells in a non-contiguous range in Smartsheet? =SUM(COUNTIF(INDIRECT({'Range","Range"}),"<>" & "")) is not supported. Thanks.
