-
Direct a new form to an old form URL
Hello All, I'm moving to a new sheet with different column headings and different information. I need to keep the old one. I know the workaround will be to save a copy of the old sheet for my archive and use the original sheet to build the new one. But I'd like to start from scratch (in fact, I already have!). I would like…
-
Can I edit the way data is shown on an axis and limit the data being shown?
Hi, I have a few questions about chart formatting in smartsheet. Chart is referenced below, and my questions are as follows: Is there a way I can reduce the number of dates shown on the horizontal access but still retain the granularity in the data set? Is there a way to change the formatting of the date itself (e.g.…
-
Real Estate Asset Management
Hi, I am relatively new to Smartsheet and I have a question about setting up a Process Workflow with my team to onboard clients. My process will include automation of the process with multiple team members and collecting information on multiple properties at the same time. Can I do all of this in one smartsheet and are…
-
Forms/ Survey
Hi Team - quick question on smart sheet. I created a survey based on a template I already created but would like to separate it from showing in the same form so I can give access to other users. Do you know how I can go about doing so?
-
Conditional Formatting to add days to date based on risk category
Please help. I am trying to work with two columns: A Risk Category column which consists of High, Medium, and Low categories;. And a Committed Closure Date column which, depending on the risk category, is the date by which the gaps must be closed. Here is what I have which has not worked. The columns are already of the…
-
When a new row is created in smartsheet get the data from that new row and use it in Power Automate
I am trying to extract data from a sheet using power automate. I keep on getting an error as there are certain columns in my sheet that have floats. Is there a way around this?
-
Should collaborator's have a license to edit my Sheet?
Hi everyone, I'm a new user and currently building an information system with Smartsheet. I have read the Plan but want to make sure with this question. Question : With Pro Plan (current), is not enough to run such a system (description below), isn't ? If i upgrade to Business, is it enough ? Description : With Pro Plan…
-
Email a Report to a list of email addresses created dynamically from a sheet
I have several reports that I would like to send out to people who do not have access to SmartSheet. I can go into the report and "Send as Attachment" and enter their names. But It would be easier to have a sheet with a list of emails in one column and "Send as Attachment" to that list of addresses. It would be even nicer…
-
summarize content from smartsheets in columns
Hi I have a question about report creation. I have a smartsheet per project or product, which lists the always same process steps one below the other to standardize the project or product launch. Each row with each process step contains many columns with different information - including one column with a "completed"…
-
IF(ISDATES and Blanks)
=IF(ISDATE([A]@row), IF([A]@row < TODAY(), "Expired", "Valid"), IF(ISDATE([B]@row), IF([B]@row < TODAY(), "Expired", "Valid"), IF(ISDATE([C]@row, "Valid", IF(ISDATE([D]@row, IF([D]@row < TODAY(), "LATE", "Out for Quote"))))))) I have the following statement above. I'm trying to have it say "Late" if Column C has no date…