-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
Header
I want to add a fixed header that displays above rows on my sheet. I see this is available when printing the sheet, but I need to add instructions and clarification to the published sheet that is viewable by collaborators.
-
Merged: Group Columns
This discussion has been merged.
-
Merged: Copy Doc Mapping when Copying sheet.
This discussion has been merged.
-
How to match clinical trials to subjects based on eligibility criteria columns?
Hello, I have 2 sheets and I want to pull information from sheet to another sheet if certain criteria are met. The first sheet, "Slot List", is a list of clinical trials and the columns contain the study name and certain eligibility criteria patients need to meet to join the study. On the second sheet, "Trial Match", is a…
-
Does Smartsheet's offer something like MSFT CoPilot
Is there any AI assistance available in Smartsheet's?
-
How to have users only able to see and edit rows assigned to them?
Hi We have a number of sheets spread over different workspaces. We only want the users to be able to see and edit tasks allocated to them. We do not want them to be able to see information on sheets that is allocated to others. Initially I thought that I could set up a sheet(s) and allocate rows to a specific user. I was…
-
Baseline vs Target Dates
Hi, In the PMO template we have both baseline and target dates. What is the difference between these? The target date seems redundant. Thanks
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Formulas not updating when new data is added to underlying sheet
When new data is added or updated to the underlying sheet, the formulas are not recalculating. I run an upload workflow each morning and want the metrics sheet below to recalculate based on the updated report I attach. I have to manually re-enter the formula to get an updated metric. The counts, averages and formulas using…
