-
Find (CTRL+F) Values in Contact Column
It appears impossible to find values in a contact column using a CTRL+F/Command+F find function. I've attempted searching by the contact name (Joe Smith), contact email (joesmith@company.com), and even the messier value that copies and pastes out of a given contact cell (Joe Smith <joesmith@company.com>). I need to find…
-
alert with specific row
How can I set up to send an alert for specific row when it matched a condition . I tested it and it triggers correctly but always send the first row. for example, it should send out the 10/10/2022 row only, but it sends out 10/2/2022 row any idea? Thank you
-
A cross sheet formula that reference back to the main sheet?
Hi all! I'd be very grateful for your help... I have a Smartsheet where I would like to have an index match or vlookup formula or similar, which references a secondary sheet. The problem is that the relevant field in the secondary sheet contains a formula that needs to reference back to the main sheet. I have made up some…
-
What's the efficient to collect new info for old intake sheet?
Hello, I have an intake sheet that we've been using for a year. Today, we added a new column and we need to collect the info for that column. I have a contact list column. No one has access to this sheet except our team. What's the most efficient way to do this exercise? Thank you in advance 🙂
-
Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then not break the reports and hence the widgets in the dashboards using those reports as source.
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Can you vary working days as part of duration?
I have some tasks that can only occur M-F in a schedule, and I have some other tasks that occur throughout a weekend. I don't know how to give the days different designations. I know there is a way on MS Project, but I have not figured it out for Smartsheet.
-
Help with IF Statement with multiple SUMIFS
Hello, I am trying to sum up a range of data from two spreadsheets based on the same criteria. Here is my formula which is throwing an #UNPARSABLE error and I cannot understand why =IF(SUMIFS({Advertising Total Cost}, {Hardi}, =$Region$1, {Year}, =2021, {Month}, =[OCT-21]$1, {contract}, =CATEGORY@row) AND(SUMIFS({misc…
-
Help with (date) helper column anomaly
I am using a helper column to provide a date from 'Date created' column that auto adds date and time. The helper column date can then be used to calculate days btw it and today. I am using the formula =DATEONLY([Date created]@row) but the helper column shows the day before as in the screenshot below. I have experienced the…
-
If / isBlank statement
I am having a total brain cramp and cannot figure out the formula I need for this. two columns: Task Status Closed Date There is automation setup that when someone marks a row as Task Status = Completed, it should capture the date and put it in the Closed Date column. Well, that automation works 90% of the time, but we…
