-
Output combined column name values from checkboxes.
Hi, I have a number of checkboxes, if they are checked I want to output the column value in another cell. I understand we can't reference the column values but I am able to do this: =IF([Red]1, "Red") This will return a single value if the checkbox is true. When I try something like this: =IF([Red]1, "Red", IF([Green]1,…
-
Is there any way to select only specific columns to be included in alert messages that are sent out
Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns in the sheet. I'd like to be able to select which columns are sent and included as…
-
Need report and forms to track client status
Working on a project with about 680 customers managed by 8 customer success managers. I need to track each customer's status throughout the project (will run through the year) with about 5 milestones. I'd also like to have a form so the CSMs can easily update the client's status after speaking with them, and a dashboard or…
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…
-
How to find the Nth weekday of a given month?
I'm working on a formula that will provide the date of the 3rd Thursday of the month. That much I have working, but am trying to modify it to work for any weekday of any month. As of now the first and last weeks of the month are causing issues (returning a date from previous month, returning a date in the next week, etc.).…
-
Dependencies visibility in project sheet
Improve the visibility into the task dependencies in the project sheet via function/formula or inbuilt capability to display dependent task names
-
Project Variance Formula Using Levels
I need help with a formula that calculates variance between actual durations and planned durations set at the start. We frequently need to reset the baseline throughout a 3-5 year project, and I would like a historical record of where we started and where we ended, without having to copy/paste current baselines before they…
-
Formulas referencing too many cells on source or destination sheet 👎
"Formulas are referencing too many cells on the source or destination sheet. To run this workflow, please reduce the amount of cells referenced by formulas." How do I figure out how many and what formulas are connected to the sheet causing this error? Neither the source nor destination sheets have the blue or black ▸in any…
-
Link on view-only sheet to contact sheet owner
When I have a view-only sheet open, I would like to have a link on the screen for being able to contact the sheet's owner (such as to get the sheet permissions changed so that edits can be made). Currently I have to navigate back to the previous screen where I opened the sheet from, in order to see who the owner is.
-
No idea where to start?!?!?
Hi all! New to smartsheet and struggling with formulas. Here is the sheet I am currently working with (Sheet A) I want the column labeled DC AVG to populate the total AVG for all Doc Control lines, from the Date of Inspection and any dates prior. (I manually populated the existing data in DC AVG) Similarly for LP AVG, I…
