-
Dynamic View not showing the values of a formula column that is a Read-only in the data options.
When trying to add a new item on dynamic view after i have picked my question category it should return a specific question on the next line (with no changing option, read-only). It does not show my specific question, after i hit save for the new entry it does show. But the problem is that i need the submitter to see the…
-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet if…
-
Formula to pair staff based on criteria
Hello Smartsheet community, An idea came up recently about pairing staff up who work in different divisions for a random coffee chat to increase staff engagement. We could use Smartsheet to create a form to gather info on staff who are interested in participating and what division they belong in but is there a formula I…
-
COUNTIFS Formula help in sheet summary
Hi, I currently have one field in my sheet summary which calculates the current project week. I also have one which calculates the number of tasks in the current week with the below formula, linking a column to my summary field showing the week number tasks are completed: =COUNTIFS([Projected Week Work…
-
Setting formula to match dropdown list in columns (same row, same sheet)
Hello, I need help please. Is there a way to set-up a formula so that an item in a column with dropdown list will automatically select an item in another column with a dropdown list? For example, Column A has 1,2,3 in dropdown and Column B has 4,5,6 in its dropdown list. If 1 is selected in Column A, it will automatically…
-
Control Center - Global Update Find/Replace Formula
Hi, I am testing the functionality of the Global Update feature in Control Center using the Starter Project data. Since not all my projects will have budget information available and entered in the Request Intake sheet this will generate an error on the budge variance calculation. What I would like to do is update the…
-
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
-
Need to extract Non-duplicate values
Hi, I'm in the need of extracting the Non-duplicate values in a range. I could able to achieve same in the excel (Formula =UNIQUE(A2:A16)). See the attached excel schreenshot. I knew Distinct function is a replacement of unique in smartsheet but it can be used within the other function and not working propery. Kindly…
-
Status Formula based on Date Range
Hello - I need help with a formula for a status column based on a date range (start and end columns). Status options for the formula include: Not started, Live, Completed For example, is the item has a date range from 2/21/23 to 2/28/23, the status should automatically change to "Live." If the dates in the date range are…
-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
