Sheets
Discussion List
- 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 r…
- 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 sh…
- 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 …
- 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…
- 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…
- 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({Adverti…
- 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…
- 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 = Complet…
- The following table counts data from a sheet using COUNTIFS functions. EG countif it a question and = the row or countif its an alternative proposal and the row. However the its stooped counting. For …
- Hi all, I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have: =IF([Est Effo…
