-
Project Management and Stakeholder Logs
We're using smartsheet to track a land acquisition project for a utility. Each row will contain a contact, parcel features, a dates of progress. We need a way to manage daily communication and updates. We have considered using comments and a remarks column. Is there a better solution? Thanks!
-
SMARTSHEET MERGE, HIDE SPECIFIC COLUMNS
I built a Fund Allocation Request form that makes people produce PDF for printing at the end of the process. To be able to produce the PDF, I use Smartsheet Merge. But I ran into an issue of confidentiality. Since the form is a finance thing, we don't want the users to see how much funds are requested for each items. Yet…
-
Formulas in Contact Columns
Please please please make it possible to use formulas in contact columns! :)
-
Create a Smart Form to update a row data
How do I create a form to update a data? For example, I want to just click the row line and a form will pop up so I can update it and save rather than scrolling the line item from left and right to fill in the blanks. Hope anyone could help. Thanks.
-
HOW TO REMOVE #DIVIDE BY ZERO AND MAKE CELL BLANK
I am trying to average a customer feedback section of my sheet. But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero. I use the formula =AVG([column1:column2]). What's the formula I need to use for this? I saw in the other community discussion that I can use IFERROR but I…
-
IF FORMULA TO PUT AUTOMATIC STATUS
I would like to know what can I do to put automatic status for my monitoring sheet? There are 3 status: In Transit, Cancelled and Delivered. I want to know if its possible that when the requestor input the delivery date (refer to the screenshot), the status will change to "Delivered". For the Cancelled and Transit though,…
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Automate a rent increase on certain date
I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount. I can use the Index and Match to pull in the amount, just needing…
-
Date Format
Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled to another application (Domo), but it needs the correct format when being transferred over. How…
