-
Is there an option for 'no logo' on a workspace? I don't want any logo to appear on the user forms.
I'm the SysAdmin for our company. We have our Smartsheet 'branding' options set to our company logo. We make exceptions for certain project workspaces so the specific project logo shows up on any related forms. We have a project situation where we only want the FORM TITLE to display and not show any logo at the top of the…
-
Row Limits
We are currently using Smartsheet to record the responses from our employees in a simple daily COVID symptom tracker form. We are currently exploring options to the sheet row limit and was wondering if anyone in the Smartsheet Community had any ideas or other possible solutions.
-
Formula to not Count Checkbox
I am working on building a SUMIFS formula to not count a certain row if a certain checkbox is checked in another sheet. I already have it counting everything if the criteria is correct, but having trouble adding the "NOT" if the checkbox is checked. Thanks, Kris
-
Contracts, Purchase Orders, or Change Order Management
Is anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
-
Multiple IFs then SUM
I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that project prior to a certain date. I keep all my hours worked on various projects in a work log which I am referencing from the…
-
If all = Competent then competent, if not, then inconsistent
Hi all, I need help with a formula. People choose their skill based on a certain topic: Competent Inconsistent Expert I need a formula that looks at all the children and determines that: If 1 inconsistent, no matter what else, show as inconsistent If all competent or expert, show as competent I am guessing it can be easily…
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…
-
Timeline for projects
We have several projects with us, and would like to display them all together clearly in a timeline. Unfortunately I can not find a template or anything else for this, can someone help me? for example sth like this: Thanks! Best Dominic
-
Can I pull a report based on who has access to specific reports/dashboards for governance ?
In line with GDPR, I need to be able to pull monthly reporting on who access access to specific sheets. Is this possible?
-
Sheet summary - column formula
Hello, I am creating a smartsheet that aggregates the clubs that certain employees are in. That main component is done, and I am now using the sheet summary function now (mostly using COUNTIF) to link to a dashboard. However the number of entries on the sheet will change with new employees, which makes the sheet summary…
