-
Checkbox Cross Referencing With Time Submission
Hi all, I have two sheets. Sheet A has a full list of employees with a blank checkbox column for survey completion, while Sheet B is the survey sheet that has a time-submitted column for the survey(+columns for department and employee names). What is an easy formula to use so that when an employee fills out a survey, it…
-
Is it possible to conditionally format the colors on a bar chart?
I am tracking service level across clients. In the reports I get the formulas and conditional format to work but I can't get it to translate into my charts. Is it possible?
-
Capture Sheet Data Metrics by Current Year and Quarter
I am assisting our Marketing team with tracking social media statistics year over year broken out by quarter. I want to create a sheet summary field that captures metrics for the current year and a specific quarter to populate and auto-refresh on a dashboard to avoid manually modifying the metrics each quarter/year. Is…
-
Formula to Turn Number into Date
Hi Smartsheeters! We currently have another system feeding dates into Smartsheet in a number form. For instace, this number (1695686400000) is sent to Smartsheet represents 9/26/2023. How can we convert that number into a date value in Smartsheet? Thank you for your help!
-
Automation not Automating!
Hello. I'm using the Smartsheet Individual Productivity Hub template and I can't get the Completed Tasks automated workflow to work. I've checked the automation and the condition is set that if the status is changed to complete, the action is to move the rows to another sheet. The destination sheet has been set. But, when…
-
Count if all, cells contain a specific word.
Hello, I am still new to using formulas and I am hoping someone can help with finishing this one. I have an information sheet and a metrics sheet to build a dashboard off. On the dashboard metric sheet, I am wanting to count the cells in a column ion the data sheet that contain the text "PPM" the column I am referring to…
-
IF status symbol based on cell date or blank
I'm trying to write an IF formula to return a status symbol based on if a date column in my sheet is in the past OR is blank. Smartsheet keeps telling me my syntax isn't quite wrong, and I'm having trouble seeing where I've gone wrong. Here's what my formula looks like right now. =IF(ISBLANK([Expiration Date]@row), "Red",…
-
Is it possible to divide countifs formulas
I'm trying to divide countifs formulas that are using two criterias! I've gotten it to produce a number, but the resulting number is incorrect!! I want to find the % of 'Yes' values in the Opened For field, for the Contact & Support Team. So #of Customer & Support Opened for' Yes / Total #of Customer & Support 'Opened for'…
-
Need help removing blanks from a join collect formula
Hi, I'm trying to use a join collect formula that referencing a column in a helper sheet. =JOIN(COLLECT({Column I Want Data}, {Reference Number}, [Reference Number]@row), ",") It's pulling everything from {Column I Want Data}, that matches the [Reference Number] with {Reference Number} on the helper sheet and any cell that…
-
Referencing rows
It is possible to reference a cell in a specific row, via a formula? For example, I can say [Date]@row to get the date on the current row, or [Date]3 to get the date on row 3. But I want the '3' to be a formula, which might be something like [Date]@([Reference]@row), where the value of [Reference]@row is 3.